Use of Text to Column in Microsoft Excel by WASEEM WEB WORK

Text to Column 

Today is our topic very easy and very important in Professional life but also important for students who are working in Microsoft Excel. Here the question is what is it mean?

So, the answer is that Text to Column means separation of data from one cell or column in different other columns as per requirement.

Use of Text to Column

We use this option in Microsoft Excel where we have data together numeric and text in one cell. 

for example, we have data of employe code and name together (0001001Adnan). If we have a large number of data in the same position mentioned above separation will be very difficult one by one. So we need to use the option of Text to Column which helps us and separates the data within a seconds.

Go to Data Menue ==> Select the Text to Column option

Then select Fixed width ==> and then Next ==> then select the range of data that you want to separate from the data with the help of a mouse. Then click next and click Finish. So last time you need to click okay and your data will be separated as you required.

For further explanation watch below tutorial:







For further information about our team click on WASEEMWEBWORK &

and also visit our youtube channel for more tutorials like this click here 

For contact to us, use our email Address WASEEM WEB WORK