Text to columns no delimiter

Question

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 Answer

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 Answer

Hello @BillyL14 ,

Regex will also  work.

atcodedog05 · Accepted Answer

Hi @BillyL14 ,

Use can use regex parse method for this

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

Hope this help : )

If this helps please mark the post as solution.