Hi everyone! Thanks for the help. Running LibreOffice 4.2.7.2 on Ubuntu 14.04.
I’m new to using Calc. I’ve scraped a whole bunch of information from a website onto a spreadsheet, but unfortunately, I couldn’t get it all to format properly due to the configuration of the website. I’m wondering if there’s a way to manipulate the values easily in LibreOffice Calc.
Here’s the basic issue: Column A consists of a couple thousand cells, all UserIDs. The UserID field contains more information than I’d like it to, seperated by a significant amount of whitespace. I’d like to shorten each.
So the first column looks something like this:
A1: UserID
A2: Leslie Guest
A3: Isaac Member
A4: Julia Administrator
…
A10000: Abe Guest
Note that Guest, Member, etc, could be any text.
I would like it to appear like this:
A1: UserID
A2: Leslie
A3: Isaac
A4: Julia
…
A10000: Abe
And simply have no idea how to run something like that over column A without specifying on each cell by hand, which is obviously impractical.
Anyone got any clues?