Been sorting my games from all platforms.
Now X (game) are in column A and Platform in column B.
Now i want to sort everything in column A but also include column B
However for some reason i can't get it to work either just column A is sorted or column B is sorted.

So i am getting:
A GOG
B GOG
Z GOG
A Steam

While i want:
A.GOG
A.Steam

In another occasion i had no problems with something similar so either invisible stuff in which i copied the lists from got included are somehow messing with it (there is also a game called 3089 that it sees as a number)
Or i am missing something, anyone knows what i am doing wrong?

[edit] And forgot to mark this as a question.

Not sure I understood the rest, but for 3089 you can rightclick the cell and select "Format Cells" and select "Text"

OT - This is the answers to all your Excel questions

I haven't used a proper excel for long.. Only google spreadsheet, but it should have a sort by column X...

Off the top of my head, select both columns minus the headers and select the Sort button on the Data tab and it'll give you a popup where you can choose what column you want to sort it on,
That should work probably, otherwise you might want to select the game column and RMB on it and select Cell properties and set it to Text.

Okay as to what Amok said, i did the format and set 3089 to text, then when i click both columns and sort
i am getting it like the attached picture (snap1).

3089 goes on top of the list still for some reason.
Then my whole GOG collection from a to z.
But then after that the GOG entries it sorts my steam/desura collection from a tot z how i want it (snap2) but i want GOG included.

[edit] Smannesman tip about formatting everything to text didnt help either.

I just tried it a moment ago with a fake list, when I mark colum a and b together and then go on data sort, I just sort for column A and it works fine, mixing the B one with steam and gog

Is there a space before the names? (except for 3089). Anyway, usually numbers are placed before letters.

I don't understand, however, how that sorting doesn't work.. are you selecting all columns and then sorting by column1?

Yes that is the way i tried it (and remembered from making a different list in the past) but somehow it doesn't include GOG and sorts it like the screenshot in my previous post.
I thought maybe it was an uppercase thing (as GOG is written like that but when i changed it to Gog) it did not work either.

Really strange, only reason I can see for this is what phaolo said before, a space before the gog-games name

Ah yes i forgot the GOG games have a space, it's the only way it could be copy and pasted like that from the site,
is there a way to filter that?

You have to add a second sort function when you do the sort set-up.

Sort on A column first then on B column second

Mm.. you have to get rid of that with a TRIM() function in another column or manually with Notepad++ or similar.

Years ago i had a job where i worked with excel and knew this kind of stuff, but i can't remember how to use the trim function anymore, worse case i have to it manually.

It's easy, trust me. Just:
- create another column
- paste this in the first cell (use your cell reference):
=TRIM(A1)
- extend the formula to all the column
- from now on, sort by this new column
end!

: )