space in the begining of each cell

  • Thread starter Thread starter JJP
  • Start date Start date
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
 
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
 
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
 
Back
Top