left, search mid
 

Hello
I have a spreadsheet send to me and the only thing I need to do is extract 2 numbers
1. I need to extract numbers between the first( )to one cell then
2. I need to extract numbers between the second ( ) on a different cell.

this is an example of what I get on this spreadsheet from another individual.
example in Cell C2 Verizon(295)/AT&T(254) Keep in mind the numbers can change in digits 1,2,3,4

I Need to extract to cell
A5 295
A6 254

I was thinking left and right and mid maybe.

Help please thank you

left, search mid
 

Hi Jaime,

Am Tue, 7 Jun 2016 11:27:09 -0700 (PDT) schrieb
:

this is an example of what I get on this spreadsheet from another individual.
example in Cell C2 Verizon(295)/AT&T(254) Keep in mind the numbers can change in digits 1,2,3,4

I Need to extract to cell
A5 295
A6 254

try:
=--MID(C2,FIND("(",C2)+1,FIND(")",C2)-FIND("(",C2)-1)
and
=--SUBSTITUTE(MID(C2,FIND("#",SUBSTITUTE(C2,"(","#",2 ))+1,99),")",)


Regards
Claus B.
--
Windows10
Office 2016

left, search mid
 

On Tuesday, June 7, 2016 at 1:27:12 PM UTC-5, wrote:
Hello
I have a spreadsheet send to me and the only thing I need to do is extract 2 numbers
1. I need to extract numbers between the first( )to one cell then
2. I need to extract numbers between the second ( ) on a different cell.

this is an example of what I get on this spreadsheet from another individual.
example in Cell C2 Verizon(295)/AT&T(254) Keep in mind the numbers can change in digits 1,2,3,4

I Need to extract to cell
A5 295
A6 254

I was thinking left and right and mid maybe.

Help please thank you

WORKED like a charm thank you Claus

left, search mid
 

Hi again,

Am Tue, 7 Jun 2016 20:41:35 +0200 schrieb Claus Busch:

try:
=--MID(C2,FIND("(",C2)+1,FIND(")",C2)-FIND("(",C2)-1)
and
=--SUBSTITUTE(MID(C2,FIND("#",SUBSTITUTE(C2,"(","#",2 ))+1,99),")",)

another suggestion:
=--REPLACE(REPLACE(C2,FIND(")",C2),99,),1,FIND("(",C2 ),)
and
=--SUBSTITUTE(REPLACE(C2,1,FIND("#",SUBSTITUTE(C2,"(" ,"#",2)),),")",)


Regards
Claus B.
--
Windows10
Office 2016