find position of a number in a string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Find position number of third space 6
sum numbers in cell string array 6
find and replace numeric strings in larger text strings 8
Replacing special characters in Excel 2007 3
How Do I Find Different Values In A String? 2
How to find SECOND occurrence in a string? 4
Adding recognised Zeros 5
Write a number in a cell and another number comes out in another c 2

Back
Top