How to Use the TEXT Function in Excel to Format Dates

A picture showing how to use the TEXT function in Excel to format dates.
Video Lesson:       This video lesson, titled “How to Use the TEXT Function in Excel to Format Dates,” shows you how to use the TEXT function in Excel to format dates. How to Use the TEXT Function in Excel to Format Dates:             The TEXT function in Excel lets you convert dates and
Read more
No Comments

Use Excel to Extract Address Elements from a List Exported from QuickBooks Desktop

A picture showing how to use Excel to extract address elements from a list exported from QuickBooks Desktop. The formula in this picture extracts the city data from a field containing the city, state, and zip code.
Video Lesson:       This video lesson, titled “How to Use Excel to Extract Address Elements from a List Exported from QuickBooks Desktop,” shows you how to use functions and formulas to extract address elements from a list exported from QuickBooks Desktop. How to Use Excel to Extract Address Elements from a List Exported
Read more
No Comments

Use the CLEAN Function to Remove Hidden Characters in Excel

A picture showing how to use the CLEAN function to remove hidden characters in Excel.
Video Lesson:       This video lesson, titled “How to Use the Clean Function to Remove Hidden Characters in Excel,” shows you how to use the CLEAN function to remove hidden characters in Excel. How to Use the CLEAN Function to Remove Hidden Characters in Excel:             The CLEAN
Read more
No Comments