Hello and welcome to our new video
In this video we are going to learn
I will not tell you that
I will show you, so let's go
Open excel file
And you can see some serial numbers
And here you can see some names
But this name
See all these columns
Column B, column C, column D
Or even column E
So it looks like
Rahul Rohila from
Uttar Pradesh
So what we have to do
Not in this formula
What we have to do with this data
This data is given
We have to write it in columns
The tags we have
Now how to write it
We are going to learn in this video
How to write tags to columns
So see here
Here after Rahul it looks like coma
After Deepak it looks like coma
After Nishant, Kritika, Rani
And Shiv
After that you will see here
No space is given
After this it is written
Shivam1attherate.com And here it is written
Shivam and Mishra
So what we have to do
How to write it in columns
So first
What will you do
You have to go here
Go to data
After going to data
You will see this option
So you have to select this option
Let's do it
It is saying
No data was selected
It is correct
So what we have to do
We have to select the data
So what I do
You will see here
One thing to remember here
Many people make mistakes
I have clicked on the first column
And I saw the formula
Rahul Rohila from Uttar Pradesh
But many people make mistakes
That I have to select
All these four things
So what I have to do
I have to select all
So let's do this
Let's select all
And what is the problem
Does it give us the correct result
So I selected all
Then I went to the data tab
After going to the data tab
I click here text to column
Microsoft Excel
Can convert
Only one column at a time
One column at a time
I am repeating again
Select only one column
It is not like that
If my name is going in four or five columns
Then I have to select all
Or select all the columns
Because this text to column
How does it work
It works on one column
So after doing here
Range can be many rows
Tall Range can be many rows
But Note more than one column
Wide Try again by selecting cells in one column only
So what we have to remember
Select only one column
So I click ok
Now I select only one column
The first one
And it is not like that
If you want to select one column
Select anywhere
As you have selected here
You will see nothing in the formula bar
If you click here
You will see nothing
Click here
Click on the first column
As soon as the name starts
You can see here in the formula bar
Now Now go to text to columns
When you go to text to columns
It shows you in this way
Two options
Choose the file type
First is delimited
Second is fixed width
What is the difference between these two
So what we have to select
We have to select delimited
When you select delimited
It will give you the rest of the options
What is tab, semicolon, comma, space
What we have to do
How to separate these things
Like Rahul Rohila from Uttar Pradesh
What is coming between Rahul Rohila
What is coming between Uttar Pradesh
Space What we want here
To recognize things from space
And then write in different columns
Select space
Preview Preview Preview Preview Preview Preview Preview
Preview Preview Preview Preview Preview Preview Preview we
have to do is next and in next open the tab and here in
this page remove the tab no no no here it is giving only
one thing we have to do it again press ctrl z yes ok now ok
if I click here remember these things in formula bar or
click on text to column click on delimited click on next
now here it is showing
Rahul Rohila from Uttar Pradesh preview from here what I do
I select and click on next when I click on next what it
shows me here it shows me by differentiating after that I
click on next now here you will see this option of
destination finish and next now what you have to do
whatever name is written these four columns you have to do
change the destination remove it and select these four
columns so you have given the destination of these four
columns now what will happen
Rahul will come in column j
Rohila will come in column k
From will come in column l so what I do finish it
I increase the size of column so that things are more
visible see here
Rahul, Rohila, Froma, Uttar Pradesh rest of the things you
have to do like this now here comma is given after Rahul
comma is given we want to recognize things from comma and
write here whatever is written what we have to do convert
it in column so I selected this now I selected the previous
one now I have to go again text to column and again
delimited after that next now you will see it is asking
from which you want to recognize from space or comma when
you will do from space
I will show you both when you will do from space so let's
do next I told the destination this is not the destination
I have to select it from here
I selected it and then
I selected 1,2,3,4,5,6 and 6 now I have to finish it see
here but what is it we did not separate it from comma we
separated it from space that's why it is doing the same
thing it has given comma we do not need comma we remove it
you have to select it then go to text to column after that
delimited then next now what I have to do
I have to select and differentiate see both what will it do
we remove it you can do both it will show you in preview
now it is here now what I have to do
I have to tell where I want this result so I select 6
columns and then I do finish so you will see clear
after this next thing see next thing now here there is no
space if there is no space and comma then how will you
differentiate so what you have to do select it go to text
to column see here it is fixed there is no space select it
then next see here you have to take cursor of your mouse
and you have to differentiate I want space after Rahul so
you have to click here see here after that
I have to do after Da so I will do here so here
Rahul D Rohila so we have done fixed we have differentiated
so here Rahul D Rohila now I do next when I do next and
then he will ask where do you want the result so I said I
want the result in these three columns so what I did after
doing this
I finished it so what I got is Rahul D.
Roil here it was fixed the width of the text was fixed but
still what I did
I showed it in different columns after that comes this thing
Shivam one at the rate we don't have to do this so we have
to do this thing email addresses are there if I ever need
to remove the name then how will I remove it go to text to
column go to delimited and next after next you have to go
to others what you have to do in others
I have to write at the rate from whom I want to do it came
here if I want one at the rate so I said one so the thing
with shivam came here so what I have to do next when I will
do next he will ask me where do you want the result so I
said give me the result here so what I have to do after that
I have to finish it and here shivam is also different so
shivam came with a different name and at the rate dot com
came in a different place after that shivam mishra now see
why it is showing different because there is no space so if
I click here and move it but it will be same move it there
is no use yes because it will be same rahul and space
rohila so here shivam and space so there is no use
I think you understood how we convert text in column how we
show in column
I hope you liked this video if you didn't understand
anything then you have to watch this video again
I will meet you in next video till then keep practicing