How to pull names from cell with multiple names.

[josephj]

I have a major event coming up for my organization where we are getting a couple hundred people together. Each person has an individual itinerary and so I would like to make everyone a post card that outlines their day and their meetings.

Here is a sample of the Data (Contact Info Changed to fake info)

01B	Parks 	Rep. Bill B   	520 State Office Building	651-526-5091		2:30 pm	Tessie Rick, Jim Donald, Cathy Wright
2	Finance      Sen. Rob S  	210 Capitol	                        651-526-4196		1:30 PM	Tessie Rick, Cathy Wright
02A   Infrast.      Sen. J Hill           123 Senate Office                651-125-4645              1:00pm      Jim Donald, Bill West

My excell ability is that I can do almost anything with it as long as I have a detailed set of instructions.

[JBeaucaire]

You can highlight that entire last column of names and use the DATA > TEXT TO COLUMNS function to split them out to individual cells using the comma as a delimter