View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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