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