cells of varied length extract last 3 digits

  • Thread starter Thread starter PeggyT
  • Start date Start date
P

PeggyT

each cell in a column ends with "Program ###". I would like to create a
column with just the ###. Where ### represents varied digits.
Thanks
Peggy
 
Use the formula for retreiving the last three characters / digits from a
particular cell.

For Retrieving Last Three Text Characters from a cell
=TRIM(RIGHT(A1,3))

For Retrieving Last Three Numeric Values from a cell
=--TRIM(RIGHT(A1,3))

Change the cell reference to your desired cell, if required.

If this post helps, Click Yes!
 
For Retrieving Last Three Numeric Values from a cell
=--TRIM(RIGHT(A1,3))
Click to expand...

A1 = text program 001

Your formulas return 1.

If you want the number extracted as a numeric number and to retain the 3
digit format then you'll have to use a custom number format like 000 to
display the leading 0s. Note that when doing this the leading 0s are for
display purposes only. The true value of the cell will be numeric 1.
 
Back
Top