Sort Out Text from Numbers in Excel


Q. My spreadsheets contain a mix of numbers and text. Is there a way for Excel to sort out the numbers from the text without setting up a complex formula?

A. The easy way is to use the Go To function. Here’s how it works. Create a spreadsheet with numbers in some cells and text in others. Then press Ctrl+G and you’ll get the Go To dialog screen. Now, in the lower left part of the screen, click on Special and that will bring up the screen at right.

If, for example, all you want Excel to highlight is text, select the Constants radio button and of the four square boxes (Numbers, Text, Logicals, Errors ), choose only Text. Then when you click on OK , Excel will highlight only the text entries and the spreadsheet will look like the screen at left.

While you’re at the Go To Special screen, you may want to try some of the other selections.

SPONSORED REPORT

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out