Hi
I have a bunch of data in excel which i need to clean. The format of the data is as below,
ID
ContactInfo

But the column contact data does not have a standard format. It consists of name, email id and phone number. But the problem here is the separator is not the same for all the rows. Some has comma, some has semi colon, some has pipe and some has just space. How do i segregate this into separate columns.

Any direction on this would be appreciated.