Forum Discussion
lostvol
Jul 04, 2020Copper Contributor
Paragraphs and bulleted list using text to columns
I have a column in a spreadsheet with 2500 plus rows. Within the column, is basic job description information. So you have elements Job Summary, Job Description, Primary Responsibilities with vario...
TheAntony
Jul 05, 2020Iron Contributor
lostvol1420 , the job descriptions weren't "clean". There were 14 empty ones. Also there are a few 100 items that don't conform to the structure the others are in. I fixed a few of the issues, but review thoroughly for the exceptions.
lostvol1420
Jul 05, 2020Copper Contributor
I can’t thank you enough for your help on this. Part of this project is to help make them consistent and get the information all out of one field. Your help will enable us to do that.
Thank you so much.
Thank you so much.
- SergeiBaklanJul 05, 2020Diamond Contributor
I'm not sure what is the goal, but I'd suggest to separate not only by columns but as rows as well. Please check in attached file.