Breaking into parts a string of numbers

[kas]

Hello,

I'm trying to separate a string into 2 parts - need to separate off the first two digits, which are not consistently the same numbers and the numbers aren't always the same length. I'm not great with regex, but thinking it might be the best option?

Current

1024413886
020011197682
04005364333

Desired state

Column 1    Column 2

10                24413886

02                0011197682

04                005364333

Thank you in advance

[Felipe_Ribeir0]

Hi @kas 

You can use this formula

left([Current], 2) + ' ' + right([Current], length([Current])-2)

[kas]

@Felipe_Ribeir0 

Thank you for the quick response!

I'm sorry I didn't show it clearly, but wanted them into two different columns...I could of course parse it once it's this way so I could use this as well :)

Thanks again!

Kim

[Felipe_Ribeir0 · Accepted solution]

Hi @kas 

Then you can separate the same formula

[kas]

@Felipe_Ribeir0 

Thank you, does the trick!