Partial Data Extraction 2

[telton]

Hi,

I was hoping to be able to extract data from a cell that has varying data but always xx followed by 4 numerals (e.g. xx4682) somewhere in the cell/data.

is there a formula that will extract the 4 digits after the xx.

Thank you

[alansidman]

If your data is in A1, then in B1 =MID(A1,FIND("xx",A1)+2,4)

[dredwolf]

Maybe something like this:
=MID(A1,FIND("xx",A1)+2,4)

note- this assumes that there is no possibility of 'xx' NOT being followed by 4digits though
would need to see more specific info about the data, or a sample of the data to get much more than that though

Hope this helps

[telton]

Thank you both!