To pick a random name from an Excel table using a method that works across every version of Excel, this classic combination ...

In previous versions of Excel, you had to combine first and last names using the Concatenate function, or its shortcut "&" method. Those methods are still valid in Excel 2013, but the combined data ...

When working with business data, you may encounter grouped data that needs to be divided into multiple columns. As an example, you might have a customer list that groups first and last names in a ...