| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Find first numeric value in text string
I need a formula that returns the account number and only the account number
from a text string that looks like this. BAN 123456 10/1/05-10/31/05 or ACCT 78-910 9/25/05 - 10/26/05 or 111213 1415 9/7/05 - 10/6/05 the formula that I have so far is this. =TRIM(MID(TRIM(RRLookup(A9,11)),FIND("9",TRIM(RRLo okup(A9,11))),FIND("/",RRLookup(A9,11))-2)) RRLookup is a custom function that returns text strings like the examples. This formula is for an account number that begins with 9. I want it to be more general and just start at the first numeric character. Is there a way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I convert text string into a cell reference | Excel Discussion (Misc queries) | |||
| find position of a number in a string | Excel Worksheet Functions | |||
| How to import a text file to Excel treating all input content are in string. | Excel Discussion (Misc queries) | |||
| Finding Specific Text in a Text String | Excel Worksheet Functions | |||
| Formating a text string? | Excel Discussion (Misc queries) | |||
Threaded Mode
