Data merged into one cell needs to be split

**aaronnechama** · 09-11-2009, 11:47 AM

In the attached image, I have a series of data in one cell separated by commas, and a series of values separated by commas. How do I get each data to match up with its corresponding value in the adjacent cell?http://adwordslessons.info/excel-data-image.png

**JBeaucaire** · 09-11-2009, 11:50 AM

Match up how? I imagine you need add a second sheet to your sample showing us your desired results, too.

**ravishankar** · 09-12-2009, 01:41 PM

Hi
Try the macro in the attached file
Ravi

**aaronnechama** · 09-13-2009, 11:20 PM

Ravi:
Do you have an Elance account? I would like to send you details of my project.

Aaron

**DonkeyOte** · 09-14-2009, 02:47 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

http://www.mrexcel.com/forum/showthread.php?t=415496