Search for particular text in one column and copy & Paste the (entire text) it on another column

[Yoganandhan_01]

Hello,

I need to search for "L0, L1" from the entire column A and paste the entire text of "Info: L0, Ref: L0, Reo: L0, Info: L1, Ref: L1, Reo: L1" into the column B.

Thanks.

[Ahmedx · Accepted solution]

pls try this

[Ahmedx]

or try this

[Ahmedx · Accepted solution]

pls try this

[Yoganandhan_01]

Hello @Ahmedx, 

Thanks for your solution. 

Could you please tell me the how to separate the L0 and L1 from the custom column and create a new column on it for only "L0" and "L1"

Thanks.

[Ahmedx · Accepted solution]

pls try this