Extracting Numbers a from String

G'day All,

Been awhile since I heavily used excel and need help with the following. Thank you.

I would like to extract the digits below in red. The variables are the digits in all of the sections vary from a minimum of one digit to the maximum of three digits.

111.222.333.444

Cheers

RC

ratcat, one approach:

Please Login or Register  to view this content.

where A1 holds string

Thank you very much DO.