if cell contains then copy it with 4 more characters

[Kodyzak]

Hello all,

i am not sure if it is possible with functions or i need to use VBA (if VBA please move my topic to correct thread)

I have table and in one column i have string of information and some of them contains what i need to find

Few examples:
1492(IM263685)
IM264966, testovacia validacia
1525, SEMCR_IM264966
Management - incidenty

What i need is to extract all IM26**** to another column. "IM26" is always same for all, but the next 4 characters are always different.

Thanks for help

Kody

[Olly]

Do you want all IM26xxxx values returned (including duplicates) or just the distinct values?

[alansidman]

Assume your data in Column A, then in Column B and copy down =MID(A1,FIND("IM26",A1),8)

[Kodyzak]

I am not sure if i understand you question correctly

This is what i need to achieve - From column A extract IM****** to column B

Untitled.png

[davesexcel]

Alan answer is what you are looking for

[Kodyzak]

WOW.. thas was quick.. it works perfectly

Thank you very much guys

[Glenn Kennedy]

You may need ; as the separator - not , - as you are in Slovakia.