You can put a circle around a number in Excel, using the Illustration feature, using Symbol or using the Quick Access Toolbar. Learn how!

Want to delete or truncate numbers to the left in Excel? Learning how to remove numbers in Excel from the left is a neat trick to automate subtracting unwanted digits.

For Excel to divide the values, however, the cell must contain a delimiter, a character that specifies where the first number ends and the second one begins.

Random Sort in Excel You can generate random numbers in Excel and use them in conjunction with Excel's sorting feature to have Excel randomize a list of data.