Super Trick - Split Full Name To First & Last Name in Excel

preview_player
Показать описание

इस video में हमने बताया है कि कैसे आप LEFT, RIGHT, LEN & FIND की हैल्‍प्‍ से Full Name से First Name और Last Name को अलग अलग कर सकते हैं तो आईये जानते हैं How to Split Full Name To First & Last Name in Excel

Рекомендации по теме
Комментарии
Автор

I have subscribed your channel. Just wanted to tell you I always wanted to learn from someone but you somehow makes lot of sense and the way you explained is very nice.

shahEver
Автор

Apki videos ka intjar rahta hai sir nice video

SkYadav-thhn
Автор

That's awesome...
I come across daily these things in my office...But learnt something new today...
Thanks you Sir...
बोले तो एकदम जक्कास।

gulamhussain
Автор

I love u sir ap ka batane ka trik bahut acha pura samj me ata ap mere ideal h I love u ap ke sare video acha h or helpful v sara kam karta h

UmeshKumar-qvpe
Автор

I am a regular watcher of your video. I appreciate your knowledge and presentation. Thanks

twifrtx
Автор

thanx...for adding my name sir ji...and nice video

XCELTRICKS
Автор

Sir agar text same hii or 200 se jyada row ho to kese delete karen ek baar mein, exp- elbow b16.11-2011 extn.gloery, ab hamein b16.11 ko delete kese karein

kamalrana
Автор

यह तो समझ में आ गया यहां 3 नाम है यदि चार हुए पांच नाम हुए तब कैसे अलग अलग करेंगे

dpkcreativity
Автор

Thanks sir .But appne mid k liye ni bataya .agar kisi ka name long hai jaise south indian logo ka hota hai to kaise separate karenge..Please reply..

manjeetthakur
Автор

Thanks a lot. It was really very helpful.

shikhavarshney
Автор

Thanx sir it's very helpful to us

sanjivanigeneralstores
Автор

How to split 2 spaces from name
Like
As an example my name is Ravi Kant Pandey
And i want to split all name and surname separate the how will it work done?

SIDDHARTHFF
Автор

Sir wrap text kiye hue coloum copy krne pr kisi dusre sheet me hu b hu paste kyo nhi hota. Is samsya ka samadhan btlaye.

hirmatsahu
Автор

Thanks for such a nice technique.
Sir, I am trying on a complex data like Suhail Majeed Shah S/o Abdul Majeed Shah R/o Nowgam natipora Srinagar... But I am getting errors to split the same. Please help me in this regard as my data is in complex form.

saairahmadbhat
Автор

Well sir isse simple tarika tino naam ko alg karne me hum text to collum option ka use kr k bi kr sakte h sir

sugandhaasolia
Автор

Very nice video: sir kiya formula apply karne ke bad 1st column main name change kar sakte hai

veera
Автор

Agar A collom me sabhi sell me naam ke ange shri likhna ho to kaise karenege

ravidj