I tried this one and it still leaves the 13 spaces in between.

"Don Guillett" wrote:

=trim(a3)&" " &b3

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nikki" wrote in message
...
I have a column that has a name "Nikki" followed by 13 spaces. When I
concatenate the first name with the last, I have 13 spaces between the two
names. Is there a formula that will give me only the letters in the name
and
remove the spaces?

Thanks for your help.

Nikki