software

A new problem has arisen.

I want to create a formula that will check if a certain cell has any
text and if so show that text in another cell. If there is no text, I
want excel to show nothing. I think standard is 0.

Any ideas..?

/Jonatan--
JonatanRaven------------------------------------------------------------------------
JonatanRaven's Profile: www.excelforum.com/member.php...oamp;userid=30425
View this thread: www.excelforum.com/showthread...hreadid=500992One way:

=IF(A1lt;gt;quot;quot;, A1, quot;quot;)

In article gt;,
JonatanRaven
gt; wrote:

gt; A new problem has arisen.
gt;
gt; I want to create a formula that will check if a certain cell has any
gt; text and if so show that text in another cell. If there is no text, I
gt; want excel to show nothing. I think standard is 0.
gt;
gt; Any ideas..?
gt;
gt; /Jonatan


JE McGimpsey Wrote:
gt; One way:
gt;
gt; =IF(A1lt;gt;quot;quot;, A1, quot;quot;)
gt;
gt;

Thanks a lot.. --
JonatanRaven------------------------------------------------------------------------
JonatanRaven's Profile: www.excelforum.com/member.php...oamp;userid=30425
View this thread: www.excelforum.com/showthread...hreadid=500992