IF Formula using 'text' as a condition

[EvansB2]

Hi there,

Using the IF function, I'm simply looking to return the contents of a cell only if it has text in it.

I thought the Logical test might be; IF A1 = " "

This is clearly wrong. Can anyone assist please?

Also, if the cell is blank (False)then it currently returns a 'zero'. I would like it to leave the cell blank.

Regards

Ben

 

[Fluff]

How about
=IF(ISTEXT(A1),A1,"")

 

[EvansB2]

Super. Works well.

Thanks for your swift reply.

Ben

 

[Fluff]

You're welcome & thanks for the feedback