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 |
#2
|
|||
|
|||
One way:
=MATCH(TRUE,ISNUMBER(-MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1)),0) This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it correctly, excel will wrap curly brackets {} around your formula. (don't type them yourself.) fullers80 wrote: 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 -- Dave Peterson |
Reply |
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 |