I guess the space removal feature made that question fall flat.

If you wish to remove the spaces from your data, use =trim(A1) or
=trim(A1&" "&A2&" "&A3)

If you wanted to insert more spaces, then
=A1&" "&A3
should help


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=390428