VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns)

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials

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.

⯆ DOWNLOAD the workbook & read the article: https://www.xelplus.com/excel-text-to-columns/

LINKS to related videos: VLOOKUP - https://youtu.be/hwL6KKJP-_I
★ My Online Excel Courses ► https://courses.xelplus.com

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#MsExcel

Видео VLOOKUP or SUM Not Working? Convert Text to Date? (Excel Text to Columns) канала Leila Gharani