How to convert Nan to zero

Hi guys; Please I need urgent help

I have matrix of experiment data in excel file, this excel matrix has some blank cells The problem is that the blank element shows as NaN when import the matrix to matlab for processing. Is there any function or .. to convert the Nan to zero

I appreciate your help.

Answer 1

[Laurent]

To set all NaN in Q to zero:

Q(isnan(Q))=0;

Is that what you need?

[Abdulaziz]

easy,fast and smart I really appreciate your urgent respond . Thans

[Walter Roberson]

Carlos Gamarra comments to Laurent:

Fast and simple

[raf gm]

thk

[MAHMOUD ALZIOUD]

Thank you

[Ambati Sathvik]

Thank you so much!!

Answer 2

[Santosh Shakya]

i want to replace nan with 0 in an array

can you help me?

[Walter Roberson]

a = rand(5,5)

a = 5×5

0.9293 0.2265 0.4353 0.6769 0.2335 0.7836 0.5917 0.3524 0.9278 0.9782 0.3526 0.6221 0.5509 0.6242 0.4922 0.8690 0.6174 0.6444 0.7184 0.1279 0.6544 0.5207 0.1999 0.3623 0.0036

a([2, 7, 23]) = nan

a = 5×5

0.9293 0.2265 0.4353 0.6769 0.2335 NaN NaN 0.3524 0.9278 0.9782 0.3526 0.6221 0.5509 0.6242 NaN 0.8690 0.6174 0.6444 0.7184 0.1279 0.6544 0.5207 0.1999 0.3623 0.0036

b = fillmissing(a, 'constant', 0)

b = 5×5

0.9293 0.2265 0.4353 0.6769 0.2335 0 0 0.3524 0.9278 0.9782 0.3526 0.6221 0.5509 0.6242 0 0.8690 0.6174 0.6444 0.7184 0.1279 0.6544 0.5207 0.1999 0.3623 0.0036

%OR
c = a; c(isnan(c)) = 0

c = 5×5

0.9293 0.2265 0.4353 0.6769 0.2335 0 0 0.3524 0.9278 0.9782 0.3526 0.6221 0.5509 0.6242 0 0.8690 0.6174 0.6444 0.7184 0.1279 0.6544 0.5207 0.1999 0.3623 0.0036

Answer 3

[Hernan Larriva]

Great, Thank you from Barcelona