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

Hi,

Please try this one out. Selct the range in which you have the text strings.

DataText to Columns
DelimitedNext
In "Other" field type 0 and check the "Treat consecutive delimiters as One"
field.
Click Next and Finish.

This is will shift your result to the next column so please ensure that you
have the column free.

Regards,


"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