space before cell contents
 

Hi

Had a look in previous threads to no avail

I have post codes in cells across page
A1 CV
B1 35
C1 oRR

I got CV35 in cell D1 by =A1&B1, but when added &C1 did not get the space
beween the "V" and "0"

how do I get CV35 0RR (with the space)?

Any help appriciated

regards
Brian

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200802/1