Separate data in 1 row of excel with "|" and arrange in one single line

Hi,

i have a data in one excel row like:
some name1,designation1,email1,phone1
some name2,designation2, email2,phone2
some name3,designation3, email3,phone3

i want to separate this data by “|” first and also in a single line like
some name1,designation1,email1,phone1 | some name2,designation2, email2,phone2 | some name3,designation3, email3,phone3

and then put it in a column

Thanks in advance
Mohini

Hi, in your input file there are 3 rows for separate data,
while my data is in a single row but on new line

Thanks!

@mohininemade301094

You can use REPLACE method

string_value.replace(VBLF,"|")

Thanks a lot for great help :-), it worked!!

1 Like