| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Parsing text
Is there a formula that will parse the last two numbers from this string
BACM0001? the end result should be "01". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Parsing text
With the string in cell A1
=RIGHT(a1,2) If this post helps click Yes --------------- Jacob Skaria "Confused" wrote: Is there a formula that will parse the last two numbers from this string BACM0001? the end result should be "01". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| parsing text | New Users to Excel | |||
| parsing text | Excel Discussion (Misc queries) | |||
| Parsing Number from Text | Excel Discussion (Misc queries) | |||
| Parsing text | Excel Discussion (Misc queries) | |||
| Parsing text in Excel | Excel Worksheet Functions | |||
Linear Mode
