Formula to Extract Specific Characters from a String

Can someone please help me with a formula to extract the "227120" characters between two "."'s in a string such as:

Position Title.227120.730

I will use the value of this segment in a vlookup to determine another outcome, so need to have this formula result to perform the vlookup.

The string will always contains 6 characters between the "."s

Thanks in advance

Assuming string to be searched is in A1, the following returns TEXT:
=MID(A1,SEARCH(".",A1)+1,6)

...or this if you need to convert it to a number:
=VALUE(MID(A1,SEARCH(".",A1)+1,6))

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

To return a numeric value try this.

Formula:

Please Login or Register  to view this content.

To return a text "number" try this.

Formula:

Please Login or Register  to view this content.

You're welcome. Thanks for the feedback.