remove number and "dot" at the beginning of each word

In Excel 2007, how do I remove unwanted characters from the beginning of a word (vertically down a column of words)?

I don't mean manually, I mean like a macro or some sort of automated process:

excel screenshot
LVL 5
Tom KnowltonWeb developerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Harry LeeCommented:
You can use the replace feature in Excel.

Ctrl-H, then type in *.[space]; "*. " without the quotation marks, in Find What and leave Replace with as blank, then Click Replace All.
0
Lawrence BarnesCommented:
You can also do it via formula if your data has a pattern.  In this case:
=mid(a1,search(". ",a1)+2,len(a1))

Mid function gives you a part of the cell.
Search gives the position of the period.
+2 gives the starting point of the word.
Len(a1) gives the rough number of characters to grab within the mid formula.

You can also use the split a column into columns feature.

And many other methods....
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Tom KnowltonWeb developerAuthor Commented:
Thank you, both!!  : )
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.