Hi guys,

Been looking at these forums for a while trying to learn a bit more about excel for some stuff i do at work. I'm obviously still learning.

I got a few lists of information that i have to separate from bullets in MS Word to different columns in excel, was hoping there may be a more efficient function in Excel i could use.

This is how it looks on MS Word:
• Last Name:Smith
• First Name:John
• Assignment:Human Resources
• Email:[email protected]

Each of my four colums are as follows: Last name, First Name, Assignment, Email. I need the information following the colon to go into each category, and i have about 500 of these little groups to do, which my boss wants me to do by hand. Was hoping i could impress him with a cool excel function.

Let me know if any of you knows how, until then I have to do each one manually, tired of the "Ctrl C, Ctrl V" at this point.

Thanks for anyone who can help! I appreciate it.