MS Word bullets to Excel Columns

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.

Mine assumes that your data will be imported one bullet per row exactly as shown below:

• Last Name:Smith
• First Name:John
• Assignment:Human Resources
• Email:[email protected]


My formula will extract the necessary info from each bullet.

Hi, Thanks for the help! That is how I'd like it to look, except mine is formatted differently which requires different formulas.

They look more like this:

• 1.
o Last Name:john
o First Name:Smith
o Assignment:HR
o Email Address:[email protected]
• 2.
o Last Name:John2
o First Name:Smith2
o Assignment:HR
o Email Address:[email protected]

The additional numbering/line in excel is throwing me off

Thanks for the help I appreciate it

From my previous document, in cell B2, just change any "4" in the formula to a "5". It should work fine with your formatting.