Separate a number formatted as a text but keep the leading 0s

[lastnn30]

Hi

I have text like this one

A1210-0422

B1211-0011

I want to separate into 2 columns like this

A1210    0422

B1211    0011

I used Power Query (Split/Delimiter -) but the problem I would have this

A121      422

B1211    11

It wont add 0 infront of the numbers. How can I fix that? Thank you very much.

[HotChilli · Accepted solution]

It looks like there is an additional type conversion going on.  Sometimes this gets added automatically.

If there is, you can edit/remove that step.  If not, post the Advanced Editor code and I'll have a look.