Extract Number and Text from Mix Data in Excel
Автор: Excel With Ravi
Загружено: 2020-01-10
Просмотров: 156019
Описание:
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...
Повторяем попытку...
Доступные форматы для скачивания:
Скачать видео
-
Информация по загрузке:
