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