Extract Number and Text from Mix Data in Excel
In this video you learn "How to extract Emp. ID from text (Mix Data) in Excel using a single formula.This is one of the very common situation which almost every user must have faced in his/her life. Either they get data from other team members in such a way where the mix data and they want only numbers or text.
We all know there is no particular in-built function in Excel which allows extracting number or text from mix data.
We've good way to resolve this type of problems with using a single formula only. After watching this tutorial, you will become an expert of extracting number or text from mix data).
We have created this tutorial using following features:
1. FIND FUNCTION
2. MIN FUNCTION
3. SUBSTITUTE FUNCTION
4. MID FUNCTION
In case of any simple or complicated "EXCEL" QUERY, You can join our WhatsApp Group for instant solution @
Refer this link to join group:-
https://chat.whatsapp.com/BymUIDEt3ME...
Watch video Extract Number and Text from Mix Data in Excel online without registration, duration hours minute second in high quality. This video was added by user Excel With Ravi 10 January 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 128,632 once and liked it like people.