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?

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?

Hi Jennifer,

try this formula
=(A2&" "&B2&" "&C2)
Hope this will do

"Jennifer" wrote:

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?

=a1&" "&b1&" "&c1
This will put a space between each column

"Jennifer" wrote:

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?

Thanks to everyone for their help!! This worked.

"Joey" wrote:

=a1&" "&b1&" "&c1
This will put a space between each column

"Jennifer" wrote:

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?