Extract the 6 digit value from the string

Hi All,

Hope you are doing well... let's get started my question here. i have a excel file which contains 1000 rows based on the SNOW ticket was raised ( three columns 1. subject 2.created date 3. Tkt problem).

the challenge is here the third column Please refer the screen shot it's showing warp text unable to split that and i need the split "NSI124" and "MJA268" these 6 digit numbers only.

is this possible to split the data. Thank you.

Thanks/Raju