Try
=A1&" "&B1&" "&C1 and drag it down,
Regards,
Alan.
"Jennifer" wrote in message
...
I want to merge three fields into one name field. Ex: Column A is prefix,
column B is first name and Column C is last name. I can use the formula
fine, but it doesn't add the spaces, it all runs together. Does anyone
know
a solution for this?