Thread: TRIM Help !
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Nikki Nikki is offline
external usenet poster
 
Posts: 184
Default TRIM Help !

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