Extract a Value from a Cell

[waqar1239]

Hi All,

Below is my few data values at column A.

[Functional Structure]HarmonySecurity/SymSecGroup/FFIC-0105:AUTO
[Functional Structure]AUP Site Tags/RootArea/SitePlant/Urea/FFIC-741:AUTO
[Functional Structure]AUP Site Tags/RootArea/SitePlant/Urea/FIC-103:AUTO
[Functional Structure]AUP Site Tags/RootUnit/SiteUnit/FIC-108:AUTO
[Functional Structure]AUP Site Tags/RootUnit/SiteUnit/FFIC-102:AUTO
[Functional Structure]HarmonySecurity/SymSecGroup/AIC-102:AUTO


From each cell I have to take out the following values
FFIC-0105
FFIC-741
FIC-103
FIC-108
FFIC-102
AIC-102
Kindly can some one advise me how to do this with any simple method.

Thanks a lot.

Warm Regards,

[63falcondude]

Try

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A1,"/",REPT(" ",99)),99)),":AUTO","")

[Raphaelp]

I notice that you're using Excel 2013. In that case, you can use flash fill. If you manually type the first two, then click on Data --> Data Tools --> Flash Fill, and it should work.

[waqar1239]

Thanks for your support on this. It works for me.

Thanks again, for your support.

[63falcondude]

You're welcome. Thanks for the rep.