Thread: combining text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
James James is offline
external usenet poster
  
Posts: 542
Default combining text
Enter this in Cell C1 =CONCATENATE(A1," ",B1)

"Jeanette" wrote:

Does anyone know how to combine 2 columns of text into 1? For instance if
you have an address that is in column A1 & A2 and you want all of it in
column A1?
Reply With QuoteReply With Quote