Please help to extract the particular data from huge data.

[sampath]

Hello,

I need to extract the particular data after SE**** - R from huge data. and After SE cell data also added in extracted data (output).

Herewith, I have attached the example for that.

Kindly solve this.

Regards,
Sampath.S

 

[Marc L]

Why a duplicate thread ?‼
​

 

[sampath]

Hi Marc L.

That first thread for different output( Delete particular data)
Second one is for another output ( Extract particular data)

Need two output for my job.

Kindly consider my request.

Regards,
Sampath.S

 

[Marc L]

To delete or to extract a cell, this is the same process to find it !
So you already have a code to point out the cell …

Sample to extract text :​

Sub Demo1()
    Const S = "SE3100 - R - F4R874-STOSTA"

    MsgBox Split(S, " - R - ")(1)
End Sub

Do you like it ? So thanks to click on bottom right Like !
​

 

[sampath]

Hi Marc L,

Thanks for your reply,

This code is not working to my expectation.

In the sample attachment, first sheet is input and Output sheet is having only after data of "SE**** - R - ".

Please give excel code for getting output as attachment.

Thank with regards,
Sampath.S

 

[Nebu]

Hi:
If "- R -" is present in all the strings you can use the formula as attached. The formula is in the output tab highlighted in yellow.

Thanks

 

[sampath]

Hi Nebu,

Thanks for your reply,

My request is sheet1 has input data and sheet2 is output data.

I have huge input like sheet1 and my request is extract the "SE*" from input as output sheet.

Kindly provide the solution for the same.

 

[Nebu]

Hi:

I could not make out what you want. My formula will give the output as the one showed in your output sheet, and the file you have attached is the same file for which I gave you solution for..

Thanks