Advertisement
TOPICS

Change the case of text in Excel

You can change the case of a text string in Excel by using LOWER, UPPER, and PROPER, and they are all so simple to use.

Using 3D formulas in Excel

Using 3D formulas is a easy way to manage files than summing each individual spreadsheet tab.

When autocorrect is a problem in Excel

There are two ways to solve an autocorrect problem such as the one in the question above — a temporary solution and a permanent solution.

Creating a drop-down list in Excel

Creating drop-down lists in your spreadsheets is a great way to ensure that only certain information
is entered into a cell.

FROM THIS MONTH'S ISSUE

Clean data faster using Excel’s REGEX functions

Excel’s REGEX functions provide a simpler, flexible solution to text-cleaning tasks, reducing the need to combine multiple functions when cleaning imported data. This JofA Technology Q&A article shows the way with step-by-step instructions and a video walkthrough.