View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BNT1 via OfficeKB.com BNT1 via OfficeKB.com is offline
external usenet poster
 
Posts: 125
Default 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