View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
paul paul is offline
external usenet poster
 
Posts: 11
Default merging 2 cells and adding a space.

I want to merge 2 cells into 1 and add a space.

for example I have this:
A1 = Tim
B1 = Smith
I want to make either A1 = Tim Smith or C1 = Tim Smith

How would I do this? I have tried text to column with not much luck