ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I sort in Excel with sub bulleted text? (https://www.excelbanter.com/excel-worksheet-functions/131979-how-do-i-sort-excel-sub-bulleted-text.html)

Jerome

How do I sort in Excel with sub bulleted text?
 
For example, I am organizing a new document that needs to be alphabeticalized
for easy referrence. Each topic though has sub bullets. I've tried to sort it
by highlighting the spreadsheet but it rearranges the whole text.

Is Excel the better product or would Word work better?

joel

How do I sort in Excel with sub bulleted text?
 
Microsoft Office products (such as excel) always have a lot more capability
than Microsoft Works. for Excel to do what you need it to do you have to
enter the data in the right locations and formats.

If you have something like this

Column A column B
Topic A
Sub Topic A
Sub Topic B


You may need to add a new column

Column A Column B Column C
Topic A
Topic A Sub Topic A
Topic A Sub Topic B


Then sort on new columns A & C.



"Jerome" wrote:

For example, I am organizing a new document that needs to be alphabeticalized
for easy referrence. Each topic though has sub bullets. I've tried to sort it
by highlighting the spreadsheet but it rearranges the whole text.

Is Excel the better product or would Word work better?



All times are GMT +1. The time now is 04:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com