how do I extract the last three digits from each cell in column?
To extract that as a number instead of text; try
=--RIGHT(A1,3)
or
=VALUE(RIGHT(A1,3))
If this post helps click Yes
---------------
Jacob Skaria
"PeggyT" wrote:
I am using excel 2007. Each cell in a column contain varied length of data
but ends with "Program ###". I would like to extract ### into an adjacent
column for all cells in the first column.
Thanks!
PeggyT
|