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

's Computer Specifications

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

's Computer Specifications

=RIGHT(A1,3) and copy down

Vaya con Dios,
Chuck, CABGx3

"PeggyT" <(E-Mail Removed)> wrote in message
news:0893007D-2776-42CD-942F-(E-Mail Removed)...
>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

's Computer Specifications

=RIGHT(A1,3)

"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

's Computer Specifications

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

's Computer Specifications

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.

--
Biff
Microsoft Excel MVP

"Jacob Skaria" <(E-Mail Removed)> wrote in message
news:4273174E-5EEF-4B05-96F2-(E-Mail Removed)...
> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA write macro change column with 3 number digits to 4 digits the	James C	Microsoft Excel Misc	3	25th Jan 2010 03:12 PM
Cutting first 4 digits from a cell and pasting it into an adjacent column	weewillie@anon.com	Microsoft Excel New Users	3	26th Jun 2008 09:11 PM
I need to extract the first 3 digits from a cell (ex: AAG12345)?	=?Utf-8?B?Um9i?=	Microsoft Excel Worksheet Functions	6	21st Apr 2007 11:45 PM
Extract Column Letter from Cell Reference in another Cell	JKBEXCEL	Microsoft Excel Misc	0	29th Dec 2006 03:35 PM
how do I extract hex digits in a cell and convert to binary	=?Utf-8?B?cHJzXzAxMw==?=	Microsoft Excel Worksheet Functions	3	17th Mar 2006 07:14 AM