how do I extract the last three digits from each cell in column?

P

PeggyT

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
 
J

Jacob Skaria

To extract that as a number instead of text; try

=--RIGHT(A1,3)

or

=VALUE(RIGHT(A1,3))


If this post helps click Yes
 
T

T. Valko

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cells of varied length extract last 3 digits 2
last 2 digits 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How do I ask Excel to take the.... 5
Trying to truncate or separate the first 3 characters/digits of co 4
How to specify a range from arbitrary cell and to "end of worksheet" 5
data from multiple files: best way to extract 1
Too much data in one cell 2

Top