View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default CONCATENATE text formula

=A1&" "&B1

--

Regards,

Peo Sjoblom


"Lauren" wrote in message
...
I am trying to put the text from 2 separate cells into one.

I have a name list. 925 entries.

I want to merge the first name and last name. How can I do this using

this
function, and it not being stuck together. I want it to have a space
separating first and last name. I keep trying the formula, but it doesnt
seem to be working, I know I am doing something wrong.

Any help would be greatly appreciated! Thanks!