text of cell needs to be text of another + more text

K

keyser_Soze

I want the text of cell n1 to be b1 + a string, or empty if b1 is
empty.
I currently have

=IF(B1<>"",B1,"")

which gives me the text if not empty, but how do I add my string of
text?
 
R

RagDyer

One way:
Place your string in a cell, and then refer to that cell in the formula.
Say text is in Z1:

With *no* space between B1 and Z1:

=IF(B1<>"",B1&Z1,"")

Add a space between the 2:

=IF(B1<>"",B1&" "&Z1,"")

To "hardcode" the text into the formula:

=IF(B1<>"",B1&" Your Text Here","")
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
B

Bernie Deitrick

Gord,

Why? That shouldn't result in a circular reference. The formula is in N1:
I want the text of cell n1 to be b1 + a string, or empty if b1 is empty.
Click to expand...

Bernie
MS Excel MVP
 
K

keyser_Soze

Actually, I am using the form:

To "hardcode" the text into the formula:
=IF(B1<>"",B1&" Your Text Here","")

so there should be no circular reference anyway.
 
Top