Auto Extract problem

**controlfreak** · 06-20-2012, 10:02 AM

Hi guys,

I've a sheet attached here. Basically I'm pasting this info into Excel from another program and it looks like this. I need to set up a sheet that I can repeatedly paste this info into and it will extract just a list of the underlined blue numbers with no spaces.

Thanks guys, appreciate ye having a look at this for me.

**Fotis1991** · 06-20-2012, 11:32 AM

Hi again, Today

In a Column(Let's say Column L), in L2, put this formula and copy down.

Please Login or Register  to view this content.

Is this, works for you?

**controlfreak** · 06-20-2012, 11:42 AM

Yiasou Fotis!

That works alright, ye guys are genius. My only problem with it is that it only works once. If i delete that tabel and past in a new one the formula goes. Is there any way to incorporate it into this worksheet attached. In the 'CR Sheet' tab I'd like to be able to paste this table and in the ePDM tab I'd like it to populate the B column with those numbers.
Is that possible Fotis?

Also I will be travelling to Greece this summer, back to Thassos, I can't wait! I miss the place very much.

**Fotis1991** · 06-20-2012, 12:01 PM

..Not sure that i follow you...but see the example..

So you know our islands... Thasos is an Excelent choice.. Gongr.

**controlfreak** · 06-21-2012, 04:23 AM

Thank you Fotis, you are amazing!

Andros kalos!

**Fotis1991** · 06-21-2012, 04:36 AM

Na ise kala! Efxaristo gia ta kala sou, logia!

Be well! Thank you for your good words!!

Also thanks for the feed back & reb*

I hope during your vacation in Thasos, to learn some Greek words!