| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
find position of a number in a string
How do I find the first occurrence of a number in a string? I have a list of
postcodes that will obviously have different digits. I want to go from using many FIND functions e.g., =FIND(0,A1), then =FIND(1,A2) etc... to =FIND(0-9,A1) what text would I need to put in to replace the "0-9"? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Store row number after a find | Excel Discussion (Misc queries) | |||
| How do I find the last number in a column of numbers? | Excel Worksheet Functions | |||
| Insert a Seperator into a number string. | Excel Discussion (Misc queries) | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
| How do I find the first value in a column less than a number? | Excel Worksheet Functions | |||
Threaded Mode
