YouTube: VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns) [Leila Gharani]

WATCH ON YOUTUBE NOW:
VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns)
Leila Gharani

This tutorial uses Excel's Text to Columns feature to address two common Excel problems.

Problem 1: VLOOKUP formula doesn't work

One common reason for your VLOOKUP formulas or SUMIFS formulas not working is that Excel doesn't recognize the numbers as numbers. It sees them as text. Even if you change the cell custom formatting from General to a Number, your formulas still don't work. This is a common issue when you import data to Excel from SAP or Oracle systems.

Problem 2: Dates are not recognized as dates in Excel. - sometimes imported dates from other systems to Excel are seen as text or number but not as a date. Excel's text to column feature can convert these super fast into dates.

Expand your Office skills
Explore training
Got It
Get instant Excel help
Connect to an expert now
Subject to Got It terms and conditions

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×