Extract Particular Text from Cell

[sanket_sk]

Hi All,

I have small task in hand but unable to crack.

We have text missed with alphabet and numbers, we want to extract particular part from it

i.e. –

1. Call Number 60-0016388499 allocated to Vijay he will attend today where we need to extract – “60-0016388499”
2. Consumer Mr.Akhilesh is out of town we will attend call number 60-0015508727 in next week where we need to extract – “60-0015508727”
3. One of Gov dept call registered 132434-00438 we will attend as per schedule where we need to extract – “132434-00438”

Could you please help me develop formula / VBA code to extract these details.

Sanket

 

[FormR]

Hi, if the part you want to extract are the only numbers in the text, then you could try something like this.

Book1
	A	B
1	Call Number 60-0016388499 allocated to Vijay he will attend today	60-0016388499
2	Consumer Mr.Akhilesh is out of town we will attend call number 60-0015508727 in next week	60-0015508727
3	One of Gov dept call registered 132434-00438 we will attend as per schedule where we need to extract	132434-00438
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=TRIM(LEFT(SUBSTITUTE(MID(A1,AGGREGATE(15,6,FIND({0,1,2,3,4,5,6,7,8,9},A1),1),255)," ",REPT(" ",255)),255))