#N/A errors

[Fred Tuck]

I have a formula which returns a #n/a error in a string which I need a
formula in all the cells which will turn the #N/A into a blank cell so that
another formula can read the string

 

[Kevin H. Stecyk]

Fred Tuck...

I have a formula which returns a #n/a error in a string which I need a
formula in all the cells which will turn the #N/A into a blank cell so
that
another formula can read the string

Hi Fred,

Can you try rewriting that? I couldn't follow exactly what you are looking
to do.

Maybe give us some cells and information to work with.

Regards,
Kevin

 

[Randall Parker]

Wow, what syntax. Try some punctuation next time.

Anyway, if I understand you correctly, you are stringing together cells and
you wish to replace #N/A with a space. If this is correct, here is a fix you
can try:

IF(ISERROR(cell location)," ",+cell location). If you place this in the
point of the string that you expect the error, you should get what you want.

In the alternative, you could use the COPY and PASTE SPECIAL - VALUES
commands first, and then change your IF statement to look for "#N/A". Good
luck.