Please assist me for my dashboard.

[sampath]

Hello,

I have a list of alphanumeric values in excel. and i need to extract the particular data from that list.

Example:

Input

222-756-1986-2022-SE3034-MA-RA
104-107-201-222-SE3034-H4B444-ASPRSECT-QUCESTS
999-MAN-RAS-PQR-AVA-2478-SE3034-ASPREISEI-MA-RA

Needed output

222-756-1986-2022 SE3034-MA-RA
104-107-201-222 SE3034-H4B444-ASPRSECT-QUCESTS
999-MAN-RAS-PQR-AVA-2478 SE3034-ASPREISEI-MA-RA

So need to extract after SE3034 and which to be comes to next cell.

Kindly assist me for the same.

Regards,
Sampath.S

 

[NARAYANK991]

Hi Sampath ,

Will the demarcating string always be SE3034 ? If not , what are the possibilities , and how can we know all of the them ? Do you have them listed somewhere in the worksheet ?

Narayan

 

[Deepak]

In addition what NARAYANK991 asked!!!

Assume your data in A1 then try this.

=MID(A1,SEARCH("SE3034",A1),LEN(A1))