Luckily, Excel is one step ahead of us morons, making it easy to split a column full of names into two separate columns with first and last names. Here’s how. 1. Insert a blank column If you don’t have a blank column to the right of the one currently holding your names, you need to insert a blank one. This is where your surnames will be placed.
Reveal hidden columns in Excel Thankfully, it’s dead easy to get missing columns back. There are a couple of ways to do it. By far the easiest way is to select the two columns adjacent to the missing column. You do this by clicking on, say, the B at the top of the column and then (keeping the left-mouse button clicked) dragging across to the D.
In either Excel or Microsoft Word, you can also use the Insert Symbol option that appears in the main menu. Click on the down arrow next to “Subset” and choose “Latin-1 Supplement”. The Yen symbol should appear in the first couple of lines. Now read this: How do I type the Euro symbol on a UK keyboard?
Virtual desktops are easier to create than ever. But what if you want to label them? Here's how to edit their names and change wallpapers in Windows 10 virtual desktops.
How to generate a random number in Excel or any reputable spreadsheet Excel has two different ways to produce random numbers. The first function is =RAND (), which will generate a number between 0 and 1. The more user-friendly version is =RANDBETWEEN, which generates an integer between the two numbers you set.
8BitDo makes numerous games controllers, particularly those with a retro theme. However, here I’m reviewing a rather more “standard” looking controller. No Nintendo theming or outlandish colours – it’s available in black, white or pink – but a high-quality controller that would fit in with any games system.
Here’s how to make a substantial saving on a Microsoft 365 subscription. Just to be clear, Microsoft 365 is the artist formerly known as Office 365 or Microsoft Office, and includes the desktop and mobile versions of Word, Excel, PowerPoint and other apps.
