ExcelBanter - Parsing text

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Parsing text (https://www.excelbanter.com/excel-worksheet-functions/239013-parsing-text.html)

confused

Parsing text

Is there a formula that will parse the last two numbers from this string
BACM0001?
the end result should be "01".

Jacob Skaria

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".

All times are GMT +1. The time now is 02:14 AM.