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

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!