| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding a position in a Cell using a formula
Hi,
I'm trying to find a certain data type in a cell and the position it is in. For example I have a text cell with the following in it "SomePartName 12345 ". How would i be able to find the first number position in this cell using a formula? How would i be able to find the last number position in this cell using a formula? The reason i'm looking for something like this is to be able to separate strings of text which contain the parts name and then a number after it along with spaces inbetween. Thanks for the help. Josh |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the position of the i-th non blank cell in a vertical range | Excel Worksheet Functions | |||
| Formula to return position of the next Non-blank cell in a column | Excel Worksheet Functions | |||
| Formula to return cell position | Excel Worksheet Functions | |||
| Excel formula to find position of the contents of a cell within a column. | Excel Discussion (Misc queries) | |||
| Finding Column Position | Excel Discussion (Misc queries) | |||
Threaded Mode
