Forum Discussion
Solved
Excel alphabetic sort question!
Hello!
I have around 900 rows of data in a table in excel (office 365). I am attempting to sort them alphabetically by a column in the middle of the table. The whole table is set to "text". Somehow I have two "sets" of data within the table, each alphabetizing separately, which is not ideal. Any suggestions on how to make it so I only have one set of data in the table?
Thanks!
M
- So, I assume your issue is solved right?
you can remove those spaces by trim function or selecting the column and using Find and Replace.
5 Replies
- Can you please post a dummy example?
I actually (like just as your response came in) figured it out. Somehow, a very small portion (apprx 25 entries in the column) have one to two spaces in front.
Thanks tho!
- So, I assume your issue is solved right?
you can remove those spaces by trim function or selecting the column and using Find and Replace.
