Clean Messy Data in Excel | Filter Text Only | Filter Numbers Only | Excel Tips and Tricks #shorts
Channel: Essential Excel
Date: 2023-01-11

Do you regularly have to deal with messy unorganised data in Excel?

In this tutorial we demonstrate how to use FILTER to return either the Text or Numbers from a list. We are able to do this by also using functions ISTEXT or ISNUMBER. If you enjoyed this tutorial don't forget to give it a like!

Clean Messy Data in Excel | Filter Text Only | Filter Numbers Only | #excel  Tips and Tricks!

For more Excel tips, tricks and tutorials don't forget to subscribe to @EssentialExcel channel.

Website: https://bathompsonltd.com/

Our other social accounts:

Instagram:https://www.instagram.com/essentialexcel
TikTok: https://www.tiktok.com/@essentialexcel
LinkedIn: https://www.linkedin.com/company/essential-excel/

Instructor Lead Excel Course ► https://essentialexceluk.com/products/master-excel-course

More Tutorials ► https://youtube.com/EssentialExcel

#filter #istext #isnumber #exceltutorial #exceltips #short #shorts #tutorial #exceltricks #exceltraining #exceltipsandtricks #shortvideo #excelshortvideo #excelshortcuts #excelshortcutkeys #excelshortcut