Seperating information from one cell into multiple cells

%3CLINGO-SUB%20id%3D%22lingo-sub-3091373%22%20slang%3D%22en-US%22%3ESeperating%20information%20from%20one%20cell%20into%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3091373%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20with%20a%20large%20amount%20of%20data%20but%20unfortunately%20the%20person%20that%20uploaded%20this%20has%20put%20all%20the%20information%20in%20one%20cell%20per%20line%20as%20opposed%20to%20all%20the%20rest%20of%20the%20spreadsheets%20where%20one%20cell%20has%20one%20piece%20of%20information.%20Is%20there%20a%20quicker%20way%20for%20me%20to%20separate%20them%20rather%20than%20cut%20and%20paste%20each%20line%20into%20separate%20columns%3F%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%20for%20your%20help%20with%20this%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3091373%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3091486%22%20slang%3D%22en-US%22%3ERe%3A%20Seperating%20information%20from%20one%20cell%20into%20multiple%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3091486%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F447329%22%20target%3D%22_blank%22%3E%40Mark_74%3C%2FA%3E%26nbsp%3BIf%20there%20a%20clear%20and%20distinct%20separator%20to%20split%20the%20text%20string%20by.%20you%20can%20use%20Text%20To%20Columns%2C%20found%20on%20the%20Data%20ribbon.%20It's%20a%20three%20step%20process.%20Just%20click%20and%20follow%20the%20instructions%2C%20but%20work%20on%20a%20copy%20of%20the%20data%20first%20so%20you%20can%20always%20start%20from%20scratch%20if%20the%20end%20result%20isn't%20what%20you%20want%20it%20to%20be.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Riny_van_Eekelen_0-1643622734758.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343859i3B475E94C6E64A4E%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Riny_van_Eekelen_0-1643622734758.png%22%20alt%3D%22Riny_van_Eekelen_0-1643622734758.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

2 Replies

@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.

Riny_van_Eekelen_0-1643622734758.png

 

@Riny_van_Eekelen thank you very much for your advice, I shall experiment with this now