I have a long list of name with addresses and phone numbers in this format ....

Barn Jeffery 123 Sunny Ln. Pulaski ,315-555-5555

Sarah 456 Bull Blvd. Memphis ,256-555-5555

Tara C. 7894 Pringle St. Clw. ,813-555-5555

Barnes Mathew 5821 Melody Ln. Tmp ,562-555-5555

Matthew 23B 189th St. Brooklyn ,718-555-5555

Castor Abby B. 7459 71st St. Stn ,210-555-5555

Karen 120 Tabby Trl. Seattle ,965-555-5555

Nick K. 4141 Fulton Ave. Missouri ,478-555-5555

What is the Find and Replace formula to add a comma before all the first names and/or a comma after all the last names?

link|improve this question
feedback

2 Answers

I would venture to say that there is no formula for something like that. There is no consistency and therefore no solution.

link|improve this answer
Isn't their a formula to at least add a comma before the first names? I've done it before and completely forgot how...Thx for taking the time to answer my question. – Stacey Y. Jul 6 '11 at 22:33
No, not to my knowledge. I'm sorry. – Peter Maxwell Jul 6 '11 at 23:44
feedback

Word takes accepts regular expressions in it's Find and Replace. There is a chart in here.

http://office.microsoft.com/en-us/word-help/find-and-replace-text-or-other-items-HA001230392.aspx

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.