View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Soth Soth is offline
external usenet poster
 
Posts: 55
Default help with formula


Col A Col B

John Doe

I'd like to combine John Doe in column A and B. When create a formula like
=A1 & B1, the result 'Johndoe' without space. What I like to space in
between.

Any help is appreciated.

Thanks
Soth