We have a 260+ line 8 column worksheet containing text.

Text has been obtained from other spreadsheets forwarded by other sources.

We cleared formatting, and pasted the content into our "consolidated"
spreadsheet

We want to do an alpha sort on Column A

Data - sort

But the sorrt ends up providing 2 A-Z alpha lists, instead of 1 full alpha
A-z list.

any ideas on how to correct this?