Pulling multiple groups of data from a single Cell

**panamakevin** · 08-12-2010, 03:03 PM

Hey Guys! So here is my current dilema...

I have cells that have a large batch of data in them... I need to pull out the data that follows "Insert Transactor" all the way to the next '.' There can be sometimes 10 of these in one cell... I need it to display somewhere the 'Insert Transactor - (plus the text)" in individual cells...

Is this something that is possible in Excel? I know its a crazy request, but I figured if anyone knows you guys would!

Thanks in advance for any help!

**MarvinP** · 08-12-2010, 03:58 PM

Can you attach a sample file? Go to advanced and attach...
The request seems simple enough but we need an example.

**panamakevin** · 08-12-2010, 04:13 PM

unfortunately I cannot post it in any format due to confidentiality agreements... We ended up just using word to highlight the data so that our team can pull the data somewhat easier... Thanks anyway! Sorry if I wasted anyones time...