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

  • Thread starter Thread starter keyser_Soze
  • Start date Start date
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?
 
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!
==============================================
 
Gord,

Can you explain what's circular in there - I can't see it, but am often
blind to circularity (?).

Ta

-----Original Message-----
From: Gord Dibben [mailto:gorddibbATshawDOTca]
Posted At: 29 September 2005 18:40
Posted To: microsoft.public.excel
Conversation: text of cell needs to be text of another + more text
Subject: Re: text of cell needs to be text of another + more text


And be prepared for the "circular reference" message.


Gord Dibben Excel MVP
 
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
 
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.
 
Back
Top