Hi all,
I have a spreadsheet where I have multiple names that are saved in the same cell. Eg,
• Lina KX Handa
• Chua Lim Seng
• Cecilia Chan
• Dan Koj - are all in the same cell.
I have 2 questions:
1) Is there any way there I can seperate the names into individual cells. For example Lina is stored in 1 cell and Lim Seng in another.
2) I need to run there names through a web site to check for any hit, is there any way I can do there.
Attached is a simplifed version of the file I am currently working on.
Appreciate any ideas on how to go about this.
Bookmarks