space in the begining of each cell

[JJP]

Hello

I Have 500 cells with names and some of them begin with a sapce!

How can i remove the space in the beginig of each cell.

Thanks Very Muc

 

[Guest]

If only single name not first and second name with space you can highlight and use edit replace replace space with nothing or if 2 names use formul
=if(mid(a1,1,1)=" ",mid(a1,2,len(a1)),a1
which says if cell a1 first character is a space enter cell a1 starting at character 2 and length a1 is number of characters required else enter a
Hope this helps

 

[A.W.J. Ales]

Aternative : Look at the function TRIM()

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

If only single name not first and second name with space you can highlight

and use edit replace replace space with nothing or if 2 names use formula

=if(mid(a1,1,1)=" ",mid(a1,2,len(a1)),a1)
which says if cell a1 first character is a space enter cell a1 starting at

character 2 and length a1 is number of characters required else enter a1