Required unique data from data

[Rahul Mishra]

1. N-en_SOC_PRG_AWA_AUD_CPM_FB-IG_LOALs:VVR3_NSF_0_PPG_06.12.2021_31.01.2022_
2. IN-en_SOC_PRG_AWA_BHA_CPM_FB-IG_INTTs:NAHair&Beauty:Story_NSF_0_PPG_06.12.2021_31.01.2022_

Required only below

LOALs:VVR3

INTTs:NAHair&Beauty:Story

 

[vletm]

Rahul Mishra
How did You skip next differences?
N-en... and _AUD_
IN-en... and _BHA_
=> You need to have clear rules?
... as well as how do You have plan to use this? That means ... a sample Excel-file.

 

[Rahul Mishra]

here i attached excel sheet please help me in it

 

[vletm]

Rahul Mishra
Did You answer to my questions?
... is that Your clear rule?
Here one sample ...

 

[pecoflyer]

In G2 pulled down =TRIM(RIGHT(SUBSTITUTE(TRIM(LEFT(SUBSTITUTE(A2,"_NSF",REPT(" ",99)),100)),"FB-IG_",REPT(" ",100)),40))

 

[bosco_yip]

If other data all come in the same pattern as your 2 example data,

You could used this short formula in B2 and copied down :

=MID(A2,33,LEN(A2)-65)

 

[vletm]

Rahul Mishra
If You get those Your datas eg from csv-file then
... take only needed part without any formulas.