Yet another Regexp qustion

[SReopelle]

I've seen the post to find (6 consecutive numbers adjacent to each other in the string) with the solution being:

=LOOKUP(10^6,MID(A1,ROW(INDIRECT("1:"&LEN(A1)-5)),6)+0)

I am trying to find the first 3 digits in a string like this:

text 777 moretext 555.

When I apply the solution above and modify the last section to find 3 digits, it finds the "555". I can't make heads or tails of the expression so I cant' figure out how to modify it to find the first 3 digits.

Can anyone help me with this please?

 

[SReopelle]

Thank you both for your expert help! I had to save the file as a Macro enabled spreadsheet first. I also had to figure out that the VB uses FirstNNN and the upper example used FirstN. No worries it all worked and I appreciate you taking the time to make me better!

 

[Peter_SSs]

Thank you both for your expert help!

You are welcome.

I had to save the file as a Macro enabled spreadsheet first.

Yep, I did tell you that.

6. Your workbook will need to be saved as a macro-enabled workbook (*.xlsm)