Thread: How to combind to cell with a <space
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
  
Posts: 1,089
Default How to combind to cell with a <space
=A1 & " " & B1 in cell C1, for example and drag down

Regards

Trevor


"Roger" wrote in message
...
I have two columns with a first name in one and the last name in the other,
I
would like to combined them into one column, what the best way to do this?
thx


Reply With QuoteReply With Quote