How To Use Text to Column in Excel Hindi
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.org/downloads
** 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.org/product or call 7722876381
Connect with us on Facebook - / excelmadeasy
Connect with us on Twitter - / excelmadeasy
Пікірлер: 57
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!
Sir ji आपका बहुत बहुत आभार एवम् शुक्रिया, लोकल बोर्ड एग्जाम रिजल्ट तैयार करना था, और डाटा पैरेंट्स का ऑब्लिक में लिखा था। बहुत परेशान था, आपके वीडियो ने मेरा काम सेकंड में कर दिया
Sir app ki avaj muze bahut pasand hai...I am your big fan thank you sir.
You are great sir.. Aapka jawab nahi hai
Thank u sir ( 34/2022) = 34 2022 karne ke liye ek saal se KZread pr khoj rha tha
Ty sir bahot badiya trick
Tysm for this lesson sir❤️🙏
wow...thank you.informative video
Shukriya mera work bahut Asaan ho gaya isse
Thanks sir very helpful video
Thank you sir....
Sir 3 column ka data aik column mein krna ho tu / lgani ho tu ye hatny ka lagany ka b trika bta dein
बहुत ही बढ़िया सर जानकारी
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 ?
Thank you
Great work
Sir kindly continue making video's on MOS in excel.
Sir Thanks...
Sir please make videos on power pivot
Please make ch. Of formatting a word document
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 mai advance excel sikhna chahtha hu. Aap mujhe pura process btayenge
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...
nice
When i am done vlookup in one cell then showing #STPL error, how to solve.
Hello sir i want a inventory file for my store .. please sir its humble request.
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 isko phone me kaise krenge
Hi Sir kindly suggest a formula to split name contain space.
@DataLearninghub
3 жыл бұрын
Use text to column or use complex function of left and find
@SIMRANKAUR-eg7nc
3 жыл бұрын
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.
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
@saudagarawais599
4 жыл бұрын
If Nested if
@atulpandey1071
4 жыл бұрын
@@saudagarawais599 thanks
Nahi ho raha h sir please help
@DINESHSINGH-wq7xr
3 жыл бұрын
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
@SIMRANKAUR-eg7nc
3 жыл бұрын
The easiest way is to copy paste though. But if u don't want that u need to progrsmme a small VBA code.
@SIMRANKAUR-eg7nc
3 жыл бұрын
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.
Saikat Mukherjee, 17/10/1987/chandannagar.....how could I deliminate this
@SIMRANKAUR-eg7nc
3 жыл бұрын
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.
@saikatmukherjee6951
3 жыл бұрын
@@SIMRANKAUR-eg7nc thanx mam...I've gone through that video... it's really helpful
@user-rl4uy9cl5w
2 жыл бұрын
बहुत सुंदर
Dislike~ apne ye nahi bataya ki delimited me kyu gaye ?
क्या दो कॉलम को जोड़ने का भी तरीका है?बताएँ। जैसे पहले कॉलम में 1 2 3 4 हो और दूसरे में different names तो क्या merge हो कर 1-name,2-neme etc हो जाये।
@DataLearninghub
3 жыл бұрын
Yes you can use concatenate method...suse below function... =A2&"-"&B2
@cbalok8693
3 жыл бұрын
@@DataLearninghub thanks
@DataLearninghub
3 жыл бұрын
@@cbalok8693 you're welcome
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.
Thank you so much sir...
@GuruJii
2 жыл бұрын
Thank you. To see our latest videos please visit www.myelesson.org/