Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
blank cell shows as a "0" in a formula
Hello,
I have an Excel 2003 worksheet where cell A1 is First Name A2 is MI ---- When they don't have a middle initial this cell is left blank. A3 is Last Name. However I have put a concatenate formula in another cell and whenever the "A2" is blank it provides a "0" instead of a blank space. A1 = Richard A2 = T. A3 = Jones would concatenate as Richard T. Jones However without a middle initial I get Richard 0 Jones. Also when there is a blank I would like to make sure it eliminates the space and simply shows Richard Jones. But the 0 problem is the biggest. This worksheet is used as a database for a WORD merged document. I've posted this before but only got one answer that wasn't appropriate, so please if anyone has an answer I really need it Thank you BOB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula contains "" but cell still shows a value | Excel Worksheet Functions | |||
Pivot tables shows "blank" | Excel Discussion (Misc queries) | |||
In Excel a cell formatted "currency" shows "######" help! | Excel Worksheet Functions | |||
Can you use a formula to make a truly "blank" cell | Excel Worksheet Functions | |||
excel formula to enter "0" if cell blank | Excel Worksheet Functions |