Formula Help

[CraigWolfenden]

I am trying to work out a formula:

If I use the formula:

=if(a1=1,"Yes","No")

I know if A1 contains 1 the cell will say yes, but if there is anything else it will say no.

However I would like to create a formula that would look at A1 and if it contains Text it would copy the text, but if not it would stay blank. I am not sure if it is possible.

Any help would be appreciated, and thank you in advance.

 

[VoG]

Try

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