On Sun, 6 Aug 2006 17:47:31 -0400, "rjr"
wrote:

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

=IF(ISBLANK(A2),A1&" "&A3,A1&" "&A2&" "&A3)

Chuck
--