software

just getting back into excel formulas... this is probally an easy
question....

i basically have a collumn full of account numbers that represent
numeric strings....

if the first position of the string is a zero, i would like to pull it
out... so 01147548 would become 1147548 -- thanks!--
clegge
------------------------------------------------------------------------
clegge's Profile: www.excelforum.com/member.php...oamp;userid=29927
View this thread: www.excelforum.com/showthread...hreadid=496235Copy an empty cell, select the numbers and do editgt;paste special and select
add, then use a format like
General and leading zeros won't show, if you need the numbers to be text you
can use a help column, assume they start in A1 in the first cell use

=IF(LEFT(TRIM(A1))=quot;0quot;,RIGHT(TRIM(A1),LEN(TRIM(A1) )-1),A1)

copy down as long as needed then paste special as values in place, now you
can remove the original column

--
Regards,

Peo Sjoblom

(No private emails please)quot;cleggequot; gt; wrote in
message ...
gt;
gt; just getting back into excel formulas... this is probally an easy
gt; question....
gt;
gt; i basically have a collumn full of account numbers that represent
gt; numeric strings....
gt;
gt; if the first position of the string is a zero, i would like to pull it
gt; out... so 01147548 would become 1147548 -- thanks!
gt;
gt;
gt; --
gt; clegge
gt; ------------------------------------------------------------------------
gt; clegge's Profile:
gt; www.excelforum.com/member.php...oamp;userid=29927
gt; View this thread: www.excelforum.com/showthread...hreadid=496235
gt;
If your cell is formated as quot;Generalquot; the leading quot;0quot; should disappear
automatically.--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: www.excelforum.com/member.php...oamp;userid=29640
View this thread: www.excelforum.com/showthread...hreadid=496235
the formula worked great... thanks!!!!!--
clegge
------------------------------------------------------------------------
clegge's Profile: www.excelforum.com/member.php...oamp;userid=29927
View this thread: www.excelforum.com/showthread...hreadid=496235