$2, $1 tells Excel that I want to reverse the order of those two strings of text, separated by a comma and a space. If I didn't include the dollar symbols, Excel would simply return "2, 1" as the ...

Q. Help! I imported 140,000 rows of data into Excel with each row containing two-digit-year dates formatted as text, but I need to display four-digit-year dates. I’ve tried numerous approaches ...

You will notice that Excel will round the number one digit to the right of the decimal ... Select a Category, select TEXT from the list box. In the section Select a Function, choose the FIXED ...

Excel’s Text functions are a major time saver if your job entails managing massive data, especially data that’s imported from other sources. Fortunately, all ASCII data is easily imported, but ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

The Text To Columns tool will “cut” those strings at any delimiter you specify, so you and your users need never again rekey data into separate columns. Tales of Excel-lence ...