- Joined
- Jul 7, 2011
- Messages
- 1
- Reaction score
- 0
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?
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?