Text to Columns

[YLYONG]

hello!

May I know how do I remove the zeros at the front of below numbers?

P. TU ID	P. TU ID
000202642460	202642460
000202642390	202642390

Thank you for your help!

[Qiu · Accepted solution]

@YLYONG 
We can use a RegEx parse with below.

0+([1-9]\d+)

[grazitti_sapna · Accepted solution]

@YLYONG, text to column reads only 1 delimiter, so in case you want to remove starting 000 you can try this,

Formula:

if StartsWith([P. TU ID],"000") then
tonumber(ReplaceFirst([P. TU ID],"000",""))
else tonumber([P. TU ID]) endif

I hope this helps!

Thanks!

[flying008 · Accepted solution]

Hi, @YLYONG 

the easy formula for you, also can add tonumber() for the outside if need.

TrimLeft(tostring([P. TU ID]),'0')

[YLYONG]

@Qiu @grazitti_sapna @flying008 Thank you all for your suggested solutions!

[grazitti_sapna · Accepted solution]

@YLYONG, if these solutions worked for you please mark them as solutions so they can help others for future reference.

Thanks!