Formatting for blank cell

  • Thread starter Thread starter igendreau
  • Start date Start date
I

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?
 
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?
 
igendreau said:
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?
Click to expand...

Tools, Options, View, Zero Values?
 
Back
Top