Split first middle and last name by using formula in excel
HTML-код
- Опубликовано: 18 сен 2024
- In this video you learn "How to extract First, Middle and Last Name from One Cell into Separate Cells 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 names are given in one single column and then they have to split into different cells by their First, Middle (If any) and Last Name.
We all know there is no particular in-built function in Excel which allows extracting first, middle and last name from a cell. But 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 names or text into different cells.
We have created this tutorial using following features:
1. TRIM FUNCTION
2. MID FUNCTION
3. SUBSTITUTE FUNCTION
4. REPT FUNCTION
5. COLUMN
In case of any simple or complicated "EXCEL" QUERY, You can join our WhatsApp Group for instant solution @ chat.whatsapp....
Thanku so much for that kind of solution.
EXCELLENT SIR. I HAVE NO WORDS TO EXPRESS MY JOY. I WILL TRY AND COMMENT AGAIN.
Thank You so much
Great video....i am searching this type formula since one month...seriously very useful video.
Sir just now applied and it is working like MAGIC.
Great 👍
Excellent explanation
Great sir 👌👌👍
Very nice .....superrr
Very good sir....mja aa gya
Thank You
bahut accha
very nice sir.
Very helpful
Thank You
Very nice video
Awesome trick
Thank you
Great vedio
Name having two words, second word should be the last name. Otherwise the formula is excellent.
Will correct this formula shortly and share with you
Nice video
Thank You
Bhai har bar text me word ke age space nhi hoga jesa apne ankit aur baki name me age space add kiya hua h
Mtlab hum pahle space add karna hoga formula write karne se pahle.
I am little bit confuse.
Sir aapko sirf formula me hi space add krna h na ki row data me.... Row data me kahi bhi space add krne ki jrurat h
Agar ankit cahuhan naam ho or last name Lana ho to equation??
Right side tap kaise kare.... Mera first name sehi hai last name nai arahai
Sir please watch video again...if still any issue please share your email id will share formula
How to use this formula in between of sheet instead of starting.
Please reply as soon ass
@@Technicaltrader. You can use same like this video example.
wonderful! but sir, I'm not comfortable...गुप्ता जी और त्यागी जी तो पीछे छूट गए। if column headings are ignored, it's perfect. but still, it needs to be perfect.
Thanks for the feedback....will upload new video with solution
Sir formula down ho raha hai but right drac nahi ho raha
Kindly whatsapp screen shot on 8449889898
rahul tyagi -- tyagi is a last name ..last name me kar k dikha..
Jarur sir will upload video on this topic shortly
@@ExcelWorldmis kyu aata nahi hai kya?
mai sikha du?
Nobody is perfect sir...you can share formula.
Everyone will see here
Tyagi uska last name hai middle name nahi
Your formula is incorrect...check your last name is not in last name cell
Dear you can change column number when first and last name coming in your data.