extract letters from a string

[deedee88]

Hi,

I need help on the following:

I have the following string - Arthur Miller.com - 44444

I need a formula to extract the com in another column. Problem is the text after the dot is not always going to be a 3 letters.

Any help will be appreciated!

 

[Jonmo1]

Problem is the text after the dot is not always going to be a 3 letters.

Any help will be appreciated!

Will it always be followed by a space?

 

[mikerickson]

If not length, what does determine the end of the result?
Could you give us some more examples of input and desired result.

And, just as a guess, =TRIM(MID(A1, FIND(".",A1&".")+1, 4))

 

[njimack]

This works providing there's only one dot in the text and the 3 characters are always followed by a space and a dash...
=MID(A1,FIND(".",A1)+1,FIND("-",A1)-FIND(".",A1)-2)