Hi cjjn,

you can also try the same using text to column wizard. Find below link for help:

Excel Text to column wizard