• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Arrays

J

Jas

Member
Hello,

I have been reading this:

http://chandoo.org/wp/2012/06/19/extract-numbers-from-text-excel/

and have been trying some code. Please see attached.

I have my number list in A4:A13 called lstNumbers and D4 contains {=FIND(lstNumbers,A1)} (entered as an array with Ctrl+Shift+Enter).

My question is why is D4 only showing the position of the first number (1) in my list in A1 and not an array of positions of all numbers in string A1?

Thank for your help.
 

Attachments

  • Test.xlsx
    10.8 KB · Views: 1
Hi Jas,

First wrap it in IFERROR something like IFERROR(FIND(lstNumbers,A1),"")

Second - if you wish see the position of all the digits...use the evaluate functionality, alternately, as per your attached

Select D1 to D10 (Direction should be from top to bottom)
Then Click F2
and now press CTRL + SHIFT + ENTER
 
You must log in or register to reply here.
Back
Top