#1   Report Post  
Old June 7th 16, 07:27 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 18
Default 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

  #3   Report Post  
Old June 7th 16, 08:00 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2016
Posts: 18
Default 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
  #4   Report Post  
Old June 7th 16, 08:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,853
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
when inserting new worksheets they read right to left not left to. Andy Setting up and Configuration of Excel 2 December 3rd 08 09:51 PM
Excel 2002: Can Vlookup search at left hand side of the table? Mr. Low Excel Discussion (Misc queries) 3 May 1st 07 03:09 PM
How to make a cell appear in upper left (top left) corner of works jeff Excel Programming 2 March 6th 07 10:14 PM
limit lookup search to left three places Roger Excel Discussion (Misc queries) 2 October 16th 06 03:33 PM
How to change the right-to-left worksheet to left-to-right workshe RAMA Excel Discussion (Misc queries) 1 July 4th 05 01:57 PM


All times are GMT +1. The time now is 11:33 AM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017