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". Som...
- 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.
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.Issue solved; I used Find and Replace!
- Great! thanks for the feedback.