- position the cursor on the bottom-right corner of the cell.
- then do one of these:
-- double click on bottom-right corner of the cell and it will "magically" extend.
-- or click&drag it until you like (usually the end of data in the other column).

Rather than making yet another column, it'd be easier in the long run if he just made sure all his data were trimmed before pasting them into the spreadsheet.

Personally, I'd copy the names of the GOG games into a text editor with trim functionality, such as Notepad++, trim them, then copy them back.

Thank you, got it the way i wanted now. :)
Also thanks to anyone else who tried to help.

To anyone interested, for getting your GOG list (which i made a topic about awhile ago) just go to your shelf and select
the mode that shows the titles of the games.
As for Steam you can easily get a list if you use a steam calculator (that calculates your worth and such).
As for Desura, it's a bit more tricky but instead of going to your actually games, just go to your collection (where you can find you keys).
With a bit of sorting in Excel it only takes a few minutes work and it's very easy.

You're welcome : )

Excel is a bit stupid about the whole alphanumeric thing. Formatting cells as text is just that, formatting. It doesn't mean that Excel will then treat the contents of those cells as text, other than for visual purposes. The thing is that the other games which start with numbers also include letters and/or other characters, which is why they are sorted properly. If you try adding a letter to 3089, you'll see that suddenly it gets sorted correctly. Of course, that's not what you want, because the game is called 3089, not 3089a.

But here's a trick: If you want excel to treat the contents of a cell as text, no matter what it would like to interpret it as, add an apostrophe to the beginning of the cell, so that 3089 becomes '3089. This tells Excel "I don't give a damn what you think it is, it's text, capiche?" Excel obeys and treats it as text, while visually removing the apostrophe because it treats it as a control character. This also means that if you were making a list of your DVD collection and happened to own the classic British sitcom 'Allo 'Allo, you would need to add an extra apostrophe at the beginning, because Excel won't display the first one.

Thanks for the trick, never knew about the ' thing.
Some games also put characters in the name like "beware planet earth" or //n.p.p.d rush// which makes them sort at the top, luckily there aren't many of them but still.

Numbers are before letters in the ASCII table. That's why when sorting numbers will be in front of them
Also I find it more convenient to have each platform in a separate column as I have games that I have on several platforms/services.

You could add another column (say C), using =A1 as the default value for the first game (assuming the first game is at row 1), then expand that downwards and it should become =A2, =A3 and so on, then change the few that uses weird characters (for example change "//n.p.p.d rush//" to simply "nppd rush"), finally hide C and use C and B to sort.

You could add the ugly-bloated but working SUBSTITUTE() function to the same TRIM() column to replace those characters.
Tell me if you want to try.

Thanks well there are like 5 entries in this one, i can still do that manually.
Maybe i will need it though in the future with some other lists but i will see when it comes to that, might just quote and bump you then.