Thread: How can I merge two columns containing text in excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
DannyS DannyS is offline
external usenet poster
  
Posts: 23
Default How can I merge two columns containing text in excel?
Use a third column, with the formula =B8&C8

If you want a space between the two use =B8&" "&C8

"Trissie" wrote:

Is it possible to merge 2 lists on excel ie 2 colmns of text into one column?
Thanks Trissie
Reply With QuoteReply With Quote