First, this week’s trivia…
Interestingly, Excel was released on Apple Macintosh computers in 1985 before it appeared in the Windows OS in 1987.
Now onto this week’s tip: Text to Columns! This tip is all about this lovely little button…
Let’s say you have a list of names you need to reformat…
…but the list has over 100 names and the thought of retyping them into the correct format sends you into a fit of despair. Not to worry – Excel can do the work for you!
- Select the list of names, and copy and paste the list into Excel (To copy and paste: First, copy by right-clicking and selecting Copy on the menu that appears, or press ctrl+C on your keyboard. Next, paste by right-clicking in the first cell in Excel and selecting Paste on the menu that appears, or press ctrl+V on your keyboard).
- Now select the column with the list by placing your cursor on the letter A.
- Then click on the Data tab in the Ribbon, and select Text to Columns in the Data tools section.
- In the window that appears, select Delimited and click Next.
- Select the item (called a "delimiter") you want to use to separate the columns. In our case, it’s a comma. However, you’ll notice in the preview section below that if we just select Comma, a weird space remains before the first names.
- To fix this, we’ll also select Space and check Treat consecutive delimiters as one. Click Next.
- Click Finish!
- Then, if you want to put them in the correct order, select Column B and cut and paste it in the column before A (To cut, right-click and select Cut on the menu that appears, or press ctrl+X on your keyboard).
- All done!