How to use text to Column in Excel | Split Text into Column | Conver No. into Text || in HINDI.

How to use text to Column in Excel | Split Text into Column | Conver No. into Text || in HINDI.
Split text into different columns with the Convert Text to Columns Wizard
Select the cell or column that contains the text you want to split.
Select Data _ Text to Columns.
In the Convert Text to Columns Wizard, select Delimited _ Next.
Select the Delimiters for your data. For example, Comma and Space. You can see a preview of your data in the Data preview window.
Select Next.
Select the Destination in your worksheet which is where you want the split data to appear.
Select Finish.
00:46 Short cut for Text to Column
01:40 Space used as Delimiter to break Text
02:40 Destination for output of Text to Column
03:00 Comma used as Delimiter to break Text
04:00 @ used as Delimiter to break Text
04:40 # used as Delimiter to break Text
04:57 / ( Forward Slash) used as Delimiter to break Text
05:18 Multiple / ( Forward Slash) used as Delimiter to break Text / Treat Consecutive Delimiter as One.
06:51 Used Of Fixed Width Method in Excel
09:15 Special Case for Text to Column using Ctrl + J in others
11:15 Using both Delimiter as well as Fixed with in Same Case
12:13 Convert number into Date
14:19 Convert number into Text
15:15 Conver text into number
16:00 Do not import (Skip) Column Method Case
Video Description:
How to use text to Column in Excel | Split Text into Column | Conver No. into Text || in HINDI.
• How to use text to Col...
1-Text to Columns-
To separate the contents of one Excel cell into separate columns, you can use the 'Convert Text to Columns Wizard'. For example, when you want to separate a list of full names into last and first names.
1. Select the range with full names.
2. On the Data tab, in the Data Tools group, click Text to Columns.
3. Choose Delimited and click Next.
4. Clear all the check boxes under Delimiters except for the Comma and Space check box.
5. Click Finish.
Note: This example has commas and spaces as delimiters. You may have other delimiters in your data. Experiment by checking and unchecking the different check boxes. You get a live preview of how your data will be separated.
How to use text to Column in Excel | Split Text into Column | Conver No. into Text || in HINDI.
Text to columns in Excel is a method that is used to separate a text into different columns based on some delimited or any fixed width. There are two options to use text to columns in Excel. One is using a delimiter where we provide a delimiter as an input such as comma space or hyphen, or we can use a fixed defined width to separate a text in the adjacent columns.
00:00 Intro How to use text to Column in Excel | Split Text into Column | Convert No. into Text || in HINDI.
#tabletennis of contents
Excel Text to Columns
Where to Find Text to Columns Option in Excel?
How to Split Text to Columns in Excel? (with Examples)
Examples #1: Split First Name and Last Name
Examples 2: Convert Single Column Data into Multiple Columns
Examples 3: Convert Date to Text Using Text to Column Option
Examples 4: Extract First 9 Characters from the list
How to use text to Column in Excel | Split Text into Column | Conver No. into Text || in HINDI
To access text to columns in Excel, go to the Data tab, then Data Tools and Text to Columns..
The keyboard shortcut to open text to columns is - ALT + A + E.
Examples #1: Split First Name and Last Name
Assume you have a list of names that includes both first and last names in a single column.
Below are the steps for splitting first name and last name into separate cells:
Select the data
Then, press “ALT + A +E.” It will open the “Convert Text to Columns Wizard.”
Now, make sure “Delimited” is selected and click on “Next.”
In the next step, uncheck “TAB” and select “SPACE” as the delimiter. If you think of double/triple consecutive spaces between the names, choose the “Treat consecutive delimiters as one” option. Finally, click on “Next.”
Select the destination cell. If you do not select a destination cell, it will overwrite the existing data set with the first name in the first column and the last name in the adjacent column. If you want to keep the original data intact, create a copy or choose a different destination cell.
Click on “FINISH.” That will split the first name and last name separately.
Note: This technique is ideal only for first names and last names. You need to use a different approach if there are initials and middle names.
Examples 2: Convert Single Column Data into Multiple Columns
The below data is in one column, and you need to convert it into 4 columns based on the heading.
From the above data, we can understand that there are four pieces of information in a single cell: “Hex No., Description,” “Hex No., Description.” Therefore, we will apply the “fixed-width” text to the columns method.
Thanks for Watching.....
Please Like & Subscribe our Channel _
• CorelDraw 2020

[@MahmoodHossain-zp4wv]

Your tutorial is very easy to understand

[@fjkitechpathshala7269]

Thanks for your compliment

[@sandyhertz8038]

Very helpful torturial. Thank youuuuu

[@thinkthank4002]

Very good explanation

[@Ridasajid2023]

very nice information and well needed

[@gungundevi8190]

Thanks for sharing

[@syedafarhath752]

Very helpful video

[@muhammadishaq7181]

Ma sha ALLAH

[@mariejoyduran2564]

thanks for info

[@honeyabrio9372]

nice explination

[@kayif04]

Very helpfull

[@dilhaichhotasa7169]

Nice

[@jadeventura209]

good info

[@markbersonda2917]

nice work

[@mohammadishaq6493]

Best regards

[@smarthenry-ph8hw]

Well explained

[@farazjaved1040]

Best tutorial for TEXT to Column 👍

[@loosigamers9221]

Nice info content

[@Gamer91-d6z]

Nice video

[@abhisaini2907]

vry helpful tutorial for learner of excel😍

[@sportsfunwithatifmazhar5235]

GOOD

[@MKhan-ut5zj]

Good

[@skyewilliams9633]

Thanks so much for this.

[@iqbalandsons5463]

Best explained

[@shayzadhusain5824]

O bhai nice

[@justyneshine7625]

Thanks for this. It's gonna help me alot at my job.

[@pushpitaadak6348]

My doubts are solved now.Thanks for sharing

[@rheaventura]

good luck

[@tejigurudatt7913]

Awasam 👍👍 nice information 👍👍

[@beigeguerilla2776]

Very helpful tutorial. Thanks for the info👍🙂

[@sabirkhanofficial238]

Beautiful 😍

[@Bihari_Comedy_666]

Nice bro

[@manzilgoraya]

Nice sharing keep it up its very use ful n informative

[@fjkitechpathshala7269]

Thanks Dear

[@spreadknowledge88]

nice keep sharing

[@pooinkitchen9912]

Best tutorial video. Thank you for sharing

[@youtubesub-xg3hm]

Wow brother nice sharing ❤❤

[@hashtagsanju]

Well explained ..thanks for this tutorial..❤

[@jikumar3714]

Very helpful tutorial 👍👍

[@RemionNarzary-ib9em]

Information accha hai bro mujhe pata nahi ta abhi tora samajh gaya

[@GeetaRani-fm6qo]

Useful information

[@mtk2576]

Nice sharing

[@petlifeguide]

Best helpful tips for Excel users, great job 👏

[@FerdusiRoza]

very helpful tutorial

[@aslamfaruqi-cf5xw]

Great information 🎉🎉

[@sammangi-sb4lp]

Best information

[@talesbyesther]

This impactful and impressive

[@gidgroove2039]

This is great nice learning frm you

[@GeetuGeetu-rl7kz]

Nice explaining

[@edgarlavapiez]

Useful tutorials

[@yamuzaken]

Very helpful love from CLONE YT 💜🥀

[@autoromo3784]

Amazing skill you have, keep it up

[@leomalu-ub1dv]

Good explanation

[@tamiwilcox8105]

Great training

[@mixplatememes]

Easy to learn tutorial, good work

[@tushardevvanshi4965]

Nice tutorial

[@RemionNarzary-kc6fk]

Keep teaching

[@unknowncyrus8554]

NYC video 😘😘😘🤞🤞

[@guineasofafrica5954]

😊😊😊Thank you appreciate the info helped me when I did not understand.

[@lovefromhearts2334]

Very excellent explanation

[@achinpur2020]

Very nice and well explained. Keep it up

[@mishalbutt5506]

Very helpful 👍

[@MousetrapRolox-xg9qo]

Great job

[@shobhitlikegod]

Great Excel tips

[@RKumar-sc6pv]

Keep it up 👍👍

[@MchourKbalTrie]

Good video, thank you for your sharing

[@JohnRaiMagar-li6mf]

Wow

[@manishasaini2893]

Excellent training skills I am happy as my doubts are clear.

[@roseberryentertainment9255]

Useful

[@laughteristhebestmedicine3222]

Well explained helped me alot

[@adabiasrar]

Informative video and good for beginners

[@zhchannel2684]

Great information

[@yakuzazen]

Love from CLONE YT 💜🥀

[@RebecaSamsungi-vm7oc]

Cool video

[@Kp_fighter_A1]

Nice👏👏👏👏👏

[@Fritzkfcyou]

Keep it up

[@estheroluwafemi1]

This Is helpful 🙌🙌🙌

[@Wolfie32688]

Excellent information.

[@pooinkitchen9912]

Wow,i found it interesting

[@junjunbvlogs]

Very nice bro

[@technicalkhadija9644]

good tutorial

[@mituakter-pn7cc]

Very easy tutorial

[@serviceskills-yh9fv]

happy to learn 😂😮

[@Rajaul-Vlog]

Best video

[@ashaswain6031]

Good information 👍

[@unicornmusicboomboom1646]

Very good tutorial

[@medicalworld3356]

Doing great job dear

[@TulshiKhan-tc7rw]

Super. ...

[@shaheervlogs8108]

Good effort.. keep it up .

[@jasodahowlader8682]

Good technic

[@SajidAli-ji6ub]

Nice information

[@nobboyffgaming8715]

Nice informatio

[@sajidali-zu6vf]

Good information

[@mohit-oe7sm]

NICE HELPFUL VIDEO

[@HamroNisdiKhabar-my1bg]

Best

[@sd-cy6po]

nice video

[@JhirudiKhabar-vd5em]

Super

[@Smart-online]

Helpful

[@vlogsbyruqayyabatool]

Informative videos

[@gadgetgenie2023]

Great excel tips, keep it up 👍

[@vlogsbyruqayyabatool]

Very infomative video

[@salmasultana9884]

Great tutorial . keep it up