Remove text leading zero in text string
 

One way, assume the text strings/numbers are in column A starting in A1

=SUBSTITUTE(A1,LEFT(A1,MATCH(TRUE,--MID(A1,ROW(INDIRECT("1:"&LEN(A1)))+1,1)0,0)),"")

Enter the formula with ctrl + shift & enter
Copy down

Regards,

Peo Sjoblom

"Cheryl B." wrote:

I've spent about an hour searching on how to remove leading zeros from a
column of text. I'm sure there's an easy way to do it ... just haven't found
it yet. This is a sample of the data and, as you can see, the number of
leading zeros vary as well as the length of the original and desired text

Original Desired
0000000002 2
00002309 2309
00002477327 2477327
00003584 3584
0001036 1036
00013180620620Y 13180620620Y