space before cell contents

[BNT1 via OfficeKB.com]

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

 

[Otto Moehrbach]

Something like:
=A1&B1&" " &C1
HTH Otto

 

[BNT1 via OfficeKB.com]

thanks for the speedy responce,
I forgot the space between the " " and put "", which obviously didnt work

regards

Something like:
=A1&B1&" " &C1
HTH Otto

Hi

[quoted text clipped - 14 lines]

regards
Brian