Remove laeding space

  • Thread starter Thread starter lehigh
  • Start date Start date
L

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
 
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.
 
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.
 
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
 
Back
Top