| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mid/Len functions
Hi,
Can anyone help me to find out this formula? Column A1 The company ABCD1237 ID:xxxxxxxxx3 ABCD company Company abcd1237 ID:xxxxxxxx4 Thankyoucompany The result I'd like to get is only the ID:xxxxxxxx3. I have a formula but it only take the first part ID:xxxxxxxxx3 ABCD company. I'd like to get rid of ABCD company portion as well. Here is my formula. =MID(O27,FIND(" ",O27)+9,LEN(O27)) Any suggestions? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
Threaded Mode
