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

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
cells of varied length extract last 3 digits 2
Cumulative formula for word table 0
Help with Sumproduct searching cell contents 2
Merging from an Excel file with graphics 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Mail Merge Directory Conditional Page Break 0
data from multiple files: best way to extract 1

Top