| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Finding Numbers with Cells that also contain letters
Hi All,
I have a column of data, the cells are filled with numbers and comments of text, they do not consistantly follow suit i.e the numbers are at the beginning of the cell necessarily. I want to be able to find where the numbers are and extract them into another field. Does anyone know of a formula that can do this? -- Adam ----------- Windows 98 + Office Pro 97 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| row numbers & column letters | Excel Discussion (Misc queries) | |||
| How do I change column labels from numbers to letters in Excel? | Excel Discussion (Misc queries) | |||
| Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Threaded Mode
