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
Yeah, that is definitely part of the issue. The data is anything but consistent. Thank you so much.....I will review and we can then work off this list versus having to cut and paste off the 2500 sections.