Removing Spaces in text

[Jay]

Hello,

How do I remove spaces from names? IE "John Doe"
= "JohnDoe". I've found formulas that remove extra
spacing, but I havn't found one that removes a 'single'
space from between the name.

Any help is greatly appreciated.

Thanks,
Jay Gustafson

 

[Domenic]

Hi Jay,

Try,

=SUBSTITUTE(A1," ","")

Hope this helps!

 

[GerryK]

=LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)

 

[David McRitchie]

Hi Jay,
You could select the column and use ctrl+H (Edit, Replace)
Hope that equal sign wasn't meant to indicate a formula.

Please don't ask how to put the spaces back in later.

 

[Ken Wright]

Edit / Replace / Replace " " with "" (leave blank)

 

[Jay]

Problem solved.

I was re-checking other posts and found my answer. It
passed by me the first time.

Thanks anyways everyone!

Jay Gustafson

 

[GerryK]

oops, Spaceless intials.

-----Original Message-----
=LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)

.