In which case they are presumably *not* spaces.
What does =CODE(MID(A3,6,1)) give you? It would be 32 if the characters
were spaces. 160 is a non-breaking space, which TRIM doesn't remove, but
see the other advice you've received in this thread.
--
David Biddulph

"Nikki" wrote in message
...
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