You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Paige" wrote in message
...
WOW!!!!! You are all awesome! Thanks for responding so quickly. Am going
with the =MID formula.....is the easiest, but keeping the other 2 for
reference also cause you never when they might come in handy. I'm just
constantly amazed at the brain power out there! Have a good weekend....

"T. Valko" wrote:

Thanks!

It's both an array and volatile but, as Bernie mentioned in his reply,
after
you get everything processed you can always CopyPaste SpecialValues to
convert to constants.

--
Biff
Microsoft Excel MVP


"Jim Thomlinson" wrote in
message
...
Impressive. This is a much better solution than mine...
--
HTH...

Jim Thomlinson


"T. Valko" wrote:

Try this array formula** :

=MID(A1,MATCH(TRUE,MID(A1,ROW(INDIRECT("1:"&LEN(A1 ))),1)<"0",0),255)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Paige" wrote in message
...
I have data formatted as text, with leading zeroes, such as 00AF234,
014F,
etc. Is there a way to remove these leading zeroes (other than VB)?
The
data could be of any length and have 0, 1, 2 or more leading zeroes.
Can't
do find/replace because other zeroes (like in the middle of the
data)
would
also be removed. Nothing I've tried seems to work, short of sorting
by
length, then doing =right. Any ideas please?