Need Formula

[cummingsea]

I need a formula that will copy into cell A1 from B1, B1 will always be text or blank, if blank than A1 also should be blank.
So if B1 is blank A1 is empty and if B1 is Miami than A1 is Miami. I got it to show me in A1 Miami when B1 had Miami in it, but when I deleted Miami from B1, then A1 would show me 0 or TRUE or FALSE I used two different formulas.
Thank you for your help.

 

[hkaplan2]

In A1, enter:=if(B1="","",B1)

 

[cummingsea]

I will try it.
That did the trick thank you.

 

[alansidman]

Try this: =IF(ISTEXT(B1),B1,"") Put this in cell A1 and copy down as appropriate

Alan