| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| when inserting new worksheets they read right to left not left to. | Setting up and Configuration of Excel | |||
| Excel 2002: Can Vlookup search at left hand side of the table? | Excel Discussion (Misc queries) | |||
| How to make a cell appear in upper left (top left) corner of works | Excel Programming | |||
| limit lookup search to left three places | Excel Discussion (Misc queries) | |||
| How to change the right-to-left worksheet to left-to-right workshe | Excel Discussion (Misc queries) | |||
Threaded Mode
