Formatting for blank cell

[igendreau]

I have a workbook that is fairly text based in Excel. One worksheet
1, the user has to fill in all kinds of client info (Client name,
address, zip, etc...). I want worksheet 2 to pull from worksheet 1 if
there is text to pull from, but be blank if there isn't.

Example: I have a "Client Name" cell on worksheet 1 & 2. On worksheet
2, I want that field equal to the field on worksheet 1, if there is
text in it. If it's blank, I want my field to be blank.

I tried just doing the "=MyCellNumberFromPage1", which works if there
is text on worksheet 1, but puts in a zero if the cell on worksheet 1
is blank. How do I get rid of that zero?

 

[RagDyeR]

Try this:

=IF(Sheet1!A1="","",Sheet1!A1)

--

HTH,

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

I have a workbook that is fairly text based in Excel. One worksheet
1, the user has to fill in all kinds of client info (Client name,
address, zip, etc...). I want worksheet 2 to pull from worksheet 1 if
there is text to pull from, but be blank if there isn't.

Example: I have a "Client Name" cell on worksheet 1 & 2. On worksheet
2, I want that field equal to the field on worksheet 1, if there is
text in it. If it's blank, I want my field to be blank.

I tried just doing the "=MyCellNumberFromPage1", which works if there
is text on worksheet 1, but puts in a zero if the cell on worksheet 1
is blank. How do I get rid of that zero?

 

[Guest]

hi

=IF(Sheet1!A1<>"",Sheet1!A1,"")

regards
FSt1

 

[Jordon]

I have a workbook that is fairly text based in Excel. One worksheet
1, the user has to fill in all kinds of client info (Client name,
address, zip, etc...). I want worksheet 2 to pull from worksheet 1 if
there is text to pull from, but be blank if there isn't.

Example: I have a "Client Name" cell on worksheet 1 & 2. On worksheet
2, I want that field equal to the field on worksheet 1, if there is
text in it. If it's blank, I want my field to be blank.

I tried just doing the "=MyCellNumberFromPage1", which works if there
is text on worksheet 1, but puts in a zero if the cell on worksheet 1
is blank. How do I get rid of that zero?

Tools, Options, View, Zero Values?