Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells of varied length extract last 3 digits
each cell in a column ends with "Program ###". I would like to create a
column with just the ###. Where ### represents varied digits. Thanks Peggy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells of varied length extract last 3 digits
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
cells of varied length extract last 3 digits
For Retrieving Last Three Numeric Values from a cell
=--TRIM(RIGHT(A1,3)) 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 "Ms-Exl-Learner" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract text on right of various length from cells | Excel Discussion (Misc queries) | |||
To extract the number if there is niumeric in right most digits | Excel Discussion (Misc queries) | |||
how to extract digits from a row of numbers | Excel Worksheet Functions | |||
Insert data with length between 11 OR 15 digits | Excel Worksheet Functions | |||
I need to extract the first 3 digits from a cell (ex: AAG12345)? | Excel Worksheet Functions |