Forum Discussion
Splitting out data from a single cell into multiple columns
The errors are due to following entries which don't follow the protocol. I have handled these now and worked out file can be downloaded from here - https://1drv.ms/x/s!Akd5y6ruJhvhuhBymtSFvgi2jtGl?e=33JnxK
Can you copy and paste some sample data in Excel and post Excel to Onedrive/Googledrive and post the link here? Make sure to include the rows which give out errors.
Only that column which contains these data will do good.
Hi Vijay, I don't suppose you've had a chance to look at this?
The errors are due to following entries which don't follow the protocol. I have handled these now and worked out file can be downloaded from here - https://1drv.ms/x/s!Akd5y6ruJhvhuhBymtSFvgi2jtGl?e=33JnxK
Ah ok, that's frustrating. Thanks for your help, I think I should be able to manually edit those values in the source data to solve it. Thanks!