Thread
:
left, search mid
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Claus Busch
external usenet poster
Posts: 3,872
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
Reply With Quote
Claus Busch
View Public Profile
Find all posts by Claus Busch