space in the begining of each cell

J

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
 
T

Tina

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

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 *

Tina said:
If only single name not first and second name with space you can highlight
Click to expand...
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
Click to expand...
character 2 and length a1 is number of characters required else enter a1
 
Top