View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joel joel is offline
external usenet poster
 
Posts: 9,101
Default 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?