How To Use Text to Column in Excel Hindi
Вставка
- Опубліковано 4 лют 2025
- How To Use Text to Column in Excel so that you can Split text into different columns with the Convert Text to Columns feature in excel. Call 7722876381 for live excel classes.
You can take the text in one or more cells, and split it into multiple cells using the Convert Text to
Columns Wizard in excel.
How to split one column into multiple columns in excel
Steps to Use text to column in Excel
1 Select the cell or column that contains the text you want to split.
2 Select Data - Text to Columns.
3 In the Convert Text to Columns Wizard, select Delimited - Next.
4 Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.
5 Select Next.
6 Select the Column data format or use what Excel chose for you.
7 Select the Destination, which is where you want the split data to appear on your worksheet.
8 Select Finish.
Download Practice Files from
www.myelesson.o...
** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel- • 10 Most Used Formulas ...
Learn Basic Excel Skills For Beginners- • Learn Basic Excel Skil...
Learn the Basic of Excel for Beginners - • Learn the Basic of Exc...
10 Most Used Excel Formula- • 10 Most Used Excel For...
Learn Vlookup Formula For Beginners in Excel- • Learn Vlookup Formula ...
5 Excel Questions Asked in Job Interviews- • 5 Excel Questions Aske...
Create Speedometer Chart In Excel- • Create Speedometer Cha...
Create Pareto Chart In Excel- • Create Pareto Chart In...
How to Create Dashboard in Excel- • How to Create Dashboar...
Excel Interview Questions & Answers- • Excel Interview Questi...
To watch more videos and download the files visit www.myelesson.org
To Buy The Full Excel Course visit . www.myelesson.o... or call 7722876381
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy
Guru mean a Teacher and today we people celebrates Guru pornima to thankfull to share knowledge to us and my E Lesson is one of them sharing excel knowledge .....happy guru pornima!
Thanks 🙏
I have seen the video in many places but I am not able to explain it to anyone. Your video is very good
Welcome Manish
You are great sir.. Aapka jawab nahi hai
Sir ji आपका बहुत बहुत आभार एवम् शुक्रिया, लोकल बोर्ड एग्जाम रिजल्ट तैयार करना था, और डाटा पैरेंट्स का ऑब्लिक में लिखा था। बहुत परेशान था, आपके वीडियो ने मेरा काम सेकंड में कर दिया
Sir app ki avaj muze bahut pasand hai...I am your big fan thank you sir.
Thank you so much sir...
Thank you. To see our latest videos please visit www.myelesson.org/
Shukriya mera work bahut Asaan ho gaya isse
बहुत ही बढ़िया सर जानकारी
Thanks sir very helpful video
Thanks
Sir 3 column ka data aik column mein krna ho tu / lgani ho tu ye hatny ka lagany ka b trika bta dein
Ty sir bahot badiya trick
Thank you sir....
wow...thank you.informative video
Thank you
Tysm for this lesson sir❤️🙏
Sir Thanks...
Good
Thank u sir
( 34/2022) = 34 2022 karne ke liye ek saal se UA-cam pr khoj rha tha
Sir can you please make a video in which we can learn how to do interpolation in excel and how to write Macro of it ?
Please make ch. Of formatting a word document
nice
Great work
Hi - when I tried text to column 00-EJB-7212-01 and last value is coming as 1 instead of 01 - can you please explain how to achieve last value as 01?
Sir please make videos on power pivot
Sir g Ek tutorila bana diye...Jin sabko maine flat sale kare hain, kisse kitna paisa lena hai aisi koi sheet bana diye...please
Sir mai advance excel sikhna chahtha hu. Aap mujhe pura process btayenge
Hi Sir kindly suggest a formula to split name contain space.
Use text to column or use complex function of left and find
This video is good. If u really want to get into all aspects of text to column, do search "off to office". U will become literally an expert.
When i am done vlookup in one cell then showing #STPL error, how to solve.
Good Evening sir G, I am an accountant in real estate co. sir please make any sheet for me jis main main Site wise party ki payment details ko ek sheet ke saath connect kar sakoon
please...
Sir kindly continue making
video's on MOS in excel.
Hello sir i want a inventory file for my store .. please sir its humble request.
sir isko phone me kaise krenge
❤
Saikat Mukherjee, 17/10/1987/chandannagar.....how could I deliminate this
Text to column. U can use delimit with slash and form date with date() formula. U can check a video on "off to office" and subscribe only if u r benefited.
@@SIMRANKAUR-eg7nc thanx mam...I've gone through that video... it's really helpful
बहुत सुंदर
क्या दो कॉलम को जोड़ने का भी तरीका है?बताएँ।
जैसे पहले कॉलम में 1 2 3 4 हो और दूसरे में different names तो क्या merge हो कर 1-name,2-neme etc हो जाये।
Yes you can use concatenate method...suse below function...
=A2&"-"&B2
@@DataLearninghub thanks
@@cbalok8693 you're welcome
for ex
yadi 1 se 20 unit tak 30rs lagega
aur 21se 40 unit tak 50rs lagega
to isko kis formule se Excel me layege
If Nested if
@@saudagarawais599 thanks
Nahi ho raha h sir please help
Me is kam me 8pm se laga hu abhi 2 baj gaye h fir bhi nhi kar pa raha please help me in morning please sir
Sir yadi koi data hai usme alag alag columns me contact number hai yadi hame sirf contact number ek colom me kaise laa sakte hai
Ek hi sheet kuchh contact number kisi colom me to kuchh kisi ur colom me to kuchh kisi ur colom me please help me
The easiest way is to copy paste though. But if u don't want that u need to progrsmme a small VBA code.
This video is good. If u really want to get into all aspects of text to column, do search "off to office". U will become literally an expert.
Dislike~ apne ye nahi bataya ki delimited me kyu gaye ?
Hello Sir, Today Someone calls me and said me that She is from E lesson. And Giving Excel full courses videos for Rs 2900. That videos are Already Uploaded on Your channel. So someone is doing fraud business using your videos. And they find my mobile number from your website (where I am signed in). Please took a step.