Sorry, I shouldve clarified that I cant get the formula to work even. I am
putting the formula in a blank cell, i enter =concatenate(&A1,&B1) which is
what I need merged together, I copy the formula, do a paste special for
values. I am highlighting a1 and b1 together for it to apply to the cells.
Obviously that isnt right, because its not working. The formula is showing
up in the cell rather than the result. I do have the formula auditing mode
ON.

Thanks again!

"Peo Sjoblom" wrote:

=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!