Jan 31 2022 01:38 AM
Hi All,
I have a spreadsheet with a large amount of data but unfortunately the person that uploaded this has put all the information in one cell per line as opposed to all the rest of the spreadsheets where one cell has one piece of information. Is there a quicker way for me to separate them rather than cut and paste each line into separate columns?
Thank you in advance for your help with this
Jan 31 2022 01:52 AM - edited Jan 31 2022 01:53 AM
@Mark_74 If there a clear and distinct separator to split the text string by, you can use Text To Columns, found on the Data ribbon. It's a three step process. Just click and follow the instructions, but work on a copy of the data first so you can always start from scratch if the end result isn't what you want it to be.
Jan 31 2022 02:39 AM
@Riny_van_Eekelen thank you very much for your advice, I shall experiment with this now