Removing unwanted characters
 

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,

Removing unwanted characters
 

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:

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,

Removing unwanted characters
 

Try this link, awesome utility

http://www.asap-utilities.com/

--
Saruman

---------------------------------------------------------------------------
All Outgoing Mail Scanned By Norton Antivirus 2003
---------------------------------------------------------------------------
"Marcelo" wrote in message
...
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:

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,