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!

--------------------
(Ms-Exl-Learner)
--------------------



"PeggyT" wrote:

each cell in a column ends with "Program ###". I would like to create a
column with just the ###. Where ### represents varied digits.
Thanks
Peggy