Remove laeding space

[lehigh]

Hi All

I have a list of names that I copied from a website

All of these names have one leading space

What formula can I use to remove them?


Thanks for your help


Tom Snyder

 

[Gilles Desjardins]

Hi Tom, use "trim". Word is in B4, so formula should read:
=trim(B4). This shall remove all spaces except the spaces between words.
HTH.

 

[Ken Wright]

It's probably a non-breaking space. Take a look at my post and give Dave's macro a go. It WILL
clean the data for you.

 

[Peo Sjoblom]

Try this

=SUBSTITUTE(A1,LEFT(A1,1),"")

copy down and then copy, edit>paste special as values

or do edit>replace and in the find what box hold down alt while typing 0160
on the numpad
leave replace with box empty and click replace all

 

[lehigh]

THANK YOU, THANK YOU, THANK YOU


The SUBSTITUTE formula worked great


Tom Snyder