#Shorts | Text To Column Hidden Tricks In Excel | Never Seen Before |  Advance Excel Tips & Tricks
Channel: Abhijeetji Technical 4M
Date: 19/12/2021

#Shorts | Text To Column Hidden Tricks In Excel | Never Seen Before |  Advance Excel Tips & Tricks 



About Video
Namaskar Dosto aaj aap is video mai sikhenge ki excel mai agar aapke text mai multiple same delimeters diye gaye hain (jaise Ram,,,,,,,,Mohan******) agar aap ram aur mohan ko alag alag column mai chahte hai to aap text ko column function ka use karenge jab aap text to column function ka use karenge to aur delimeters mai comma aur star choose karenge aur aap finish karenge aisa karte hai aapke pas multiple column insert ho jayenge kyonki aapne sirf ek comma aur ek hi star select kiya hai aur baki ko excel as a text treat kar raha isliye jitene extra delimiters hai (,*) utne column wo insert kar de raha hai as text mankar agar aap sare delimeters ko ek bar mai hi hatana chahte hai to aapko treat consecutive delimiters as one option per tick karna hoga aisa karte hai aapke pas sirf do hi column insert honge ek ram ke liye aur dusre mohan ke liye 

All the images & back ground music use in this video only for education purpose and all credit goes to owner 

Disclaimer:--
Note: Copyright Disclaimer Under Section 107 of the Copyright Act 1976 allowance is made for "fair use" for purposes such as criticism  comment  news reporting  teaching  scholar ship  and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use....

Aasha karta hoon dosto aapko humare video pasend aaya hoga agar video aachha laga ho to humare channel ko subscribe karke bell icon ko press kar lijiyega kyonki hum apne channle per is type ki video lekar aate rahte hai

#shorts
#advanceexceltipsandtricks
#abhijeetjitechnical4m