#value!

[bear]

Hi,

I am using -

=MID(Master!C20,FIND(" ",Master!C20)+1,999)

But when Master!C20 is empty (No Name) I get #VALUE!

What can I do to have this cell just be empty when Master!C20 is empty

Thanks for any help

[corinereyes]

Hi bear,

Use the ISERROR function.

[Simon Lloyd]

try using

IF(ISERROR(your formula,"",your formula))

format to cure it!

[bear]

I cannot seem to get this to work.

Can you please post formula.

Thanks

[corinereyes]

try:

Please Login or Register  to view this content.

[daddylonglegs]

You don't really need ISERROR, try

=REPLACE(Master!C20,1,FIND(" ",Master!C20&" "),"")

[NBVC]

or simply....


=IF(Master!C20="","",MID(Master!C20,FIND(" ",Master!C20)+1,999))

[bear]

The only one that worked for me was -

=REPLACE(Master!C20,1,FIND(" ",Master!C20&" "),"")

From daddylonglegs

The others left cell blank even if name was present.

Just thought I would let everyone know.

Thanks for all the help, again!!!

[NBVC]

The only one that worked for me was -

=REPLACE(Master!C20,1,FIND(" ",Master!C20&" "),"")

From daddylonglegs

The others left cell blank even if name was present.

Just thought I would let everyone know.

Thanks for all the help, again!!!

I am happy that one of the formulas helped you....

but the only way mine wouldn't have worked is if you have the possibility of names with no spaces between (and your intent it to return a blank..which you did not specify)...

If that was the case, then you could modify my formula to:

Please Login or Register  to view this content.

...just FYI...