| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pulling a # from a sheet bound text string
I have several rows with the following beginning text as follows:
There are 1 projects ABC€¦ There are 14 projects ABC€¦ There are 140 projects ABC€¦ There are 1400 projects ABC€¦ Been experimenting with MID, LEFT, RIGHT to no avail where I cannot figure out how to pull the number starting at the 11th place out. That number could be from 1 to 1000. I tripping over the varying number of spaces any number in a cell might be as depicted above. The text flowing €˜project, 'ABC...' varies also€¦ Any direction as how to combine functions would be appreciated. Sincerely, Arturo |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help formula that returns a text string from another sheet | Excel Worksheet Functions | |||
| Pulling Year from a text string | Excel Worksheet Functions | |||
| What does "Workbook has no bound sheets" mean? | Excel Discussion (Misc queries) | |||
| What does "Workbook has no bound sheets" mean? | Excel Discussion (Misc queries) | |||
| pulling characters out of a string | Excel Worksheet Functions | |||
Threaded Mode
