Removing unwanted characters

R

Richard

Hi,

How would I remove leading zero's and spaces that are in front of the info
in a cell?
Also, are there any generic programs out there that have these types of
functions or macros already packaged?

Thank You,
 
M

Marcelo

Try to use is


=if(or(left(a1,1)="0",left(a1,1)=" "),mid(a1,2,255),a1)

Hope this helps
Regards from Brazil
Marcelo



"Richard" escreveu:
 
Top