Hi cjjn, you can also try the same using text to column wizard. Find below link for help: Excel Text to column wizard
Forum Rules
Bookmarks