| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
First Number in a Cell
I am trying to find a formula that will allow me to extract only the very
first number in a cell. For example, if I have the number 123456 in cell A2, I would like a formula in cell A1 that will give me only the value 1; if I have the number 234567 in cell B2, I only want the value 2 in cell B2, and so on. Further, is it possible to capture more than the first number if I need more than that? Thanks, Kelly |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
| number formatted cell | Excel Discussion (Misc queries) | |||
| Maximum Number of Cell Formats | Excel Discussion (Misc queries) | |||
| Defining a number in a cell by text then subtracting it by the tex | Excel Worksheet Functions | |||
Threaded Mode
