View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default Combining Columns Into One Column

first name in A1
second name in B1

on c1 use =B1&" "&B1


or concatenate(a1," ",b1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Té" escreveu:

If I have first name in one column and last name in another column how can I
combine the names together so they fit into one column?