Copying part cell containing text and numbers to another cell

Hi there,

I have been having trouble with figuring out the code I would use to do the following;

I need to copy the number part of the cell to another cell.
Example Numbers:

COLUMN A COLUMN B
AB.C.DE.1.1 -> 1.1
AB.C.DE.10.12 -> 10.12
AB.C.DEF.11.1 -> 11.1
AB.C.DEF.1.1 -> 1.1

I just need the numbers to be copied over to another cell leaving the original cell unchanged.
I've been using a function that recognizes some of them, but then gets confused when there are more than 2 characters (when DE is DEF). So, I need a bit of help, please.

Thank you in advanced for the help!!!!

With your example, try
=MID(MID(A1,SEARCH("E",A1),LEN(A1)),SEARCH(".",MID(A1,SEARCH("E",A1),LEN(A1)))+1,LEN(A1))
I assumed there is E letter as constans

result
1.1
10.12
11.1
1.1

If your excel has "Flash Fill" you don't even need a formula. Just manually type the first one or two, then click "Flash Fill" (Data tab, Data Tools group).

Originally Posted by Aardigspook

If there are always three sets of letters (that is, the format is always letters . letters . letters . numbers . numbers) then this will work:

Formula:

Please Login or Register  to view this content.

Thank you everyone! This one worked the best for me.