MSGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### cells of varied length extract last 3 digits

• Follow

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

```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
```
 0

```> For Retrieving Last Three Numeric Values from a cell
> =--TRIM(RIGHT(A1,3))

A1 = text program 001

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

"Ms-Exl-Learner" <Ms.Exl.Learner@gmail.com> wrote in message
news:40163A66-DD43-4B72-B6CB-6CCE843D7A33@microsoft.com...
> 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

```
 0

2 Replies
376 Views

Similiar Articles:

7/25/2012 4:40:03 AM