Text to columns no delimiter

[BillyL14]

Hi

I have a list of code that start with two letters and then between 8 and 10 numbers ie. GY783529082

I was trying to use the text to columns tool to separate the letters from the numbers but I am not really sure what to put in as the delimiter?

Thanks

[Emil_Kos · Accepted solution]

Hi @BillyL14,

maybe use the formuła tool.

Left tool and substring tool should help you.

For substring use Substring([column],3,8) and for left tool left([column],2) and you should achieve same result.

[ImadZidan · Accepted solution]

Hello @BillyL14 ,

Regex will also  work.

[atcodedog05 · Accepted solution]

Hi @BillyL14 ,

Use can use regex parse method for this

([[:alpha:]]{2})(.*)

Hope this help : )

If this helps please mark the post as solution.

[BillyL14]

@atcodedog05 

@ImadZidan @Emil_Kos 

thanks!