| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Numerical data formula
Hi Friends,
I am in requirement of a formula for extracting only last seven (or less) numerical digits from a reference. Ex - 1 - if A1 consists 112233help573847 - I need "573847". 2 - if A1 consists 112233help573 - I need "573". 3 - if A1 consists 112233help - I need "112233". 4 - if A1 consists 112233 - Ineed "112233". Any help is appriciated. Thanks, Thyag |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I run a regression on data that is not numerical? | Excel Worksheet Functions | |||
| Charting Non-Numerical Data | Excel Discussion (Misc queries) | |||
| numerical data sort | Excel Worksheet Functions | |||
| How do I total non-numerical data | New Users to Excel | |||
| Non-numerical data in a pie chart | Excel Discussion (Misc queries) | |||
Threaded Mode
