June 22, 2021
I am wondering if one of you lovely people could help me complete my excel program below. I am trying to turn 2 or more paragraphs into one paragraph and if a paragraph contains bullet points, I need excel to be able to convert them into a list with all items separated by a semi Colon.
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Excel Customer Service
November 8, 2013
Excel is not a great text processor, detecting paragraphs or sentences might be too much for a data processor.
bullet points are hard to identify, depending on how you paste data into excel might make the difference: the list might get indented, or bullet points become spaces.
For example, I pasted original data into a single cell, and the list items start with 4 spaces.
You can try replacing 4 spaces with a ; char, if this is your way of copying data from that site. If you paste data into multiple cells, list items will be indented.