Name1|Name2|Name3|Name4|Name5 abc 1 |abc2|abc3|abc4|abc5 pqr1 |pqr2|par3|pqr4|pqr5 lmn1|lmn2|lmn3|lmn4|lmn5 this my excel data and i want remove | and split data into columns

Split

Gokul001 (Gokul Balaji) August 27, 2022, 8:22am 5

You String is nothing but Input string @Yogita_Gaikwad

Topic		Replies	Views
Hi folks need a help Help	7	910	January 15, 2020
Split "," and put into each column Help excel , activities , string , question , data_manipulation	6	1831	December 26, 2019
How to divide String Help excel , activities , string , question , data_manipulation	10	1589	November 28, 2019
Seperating text Help	2	739	September 4, 2019
How to split the string? Academy Courses excel , studio , string	12	2281	November 28, 2022