ASSIGNMENT NO.4

-

  Convert Text to Columns in Excel

Converting text to columns in Excel breaks down a single column of text into multiple columns based on specified delimiters. Follow these steps to make the process a breeze:

Step 1: Select the Column

First, select the column that you want to split into multiple columns.

Make sure your data is highlighted. This tells Excel which text to work its magic on. If you only need part of the column, just highlight that section.


Step 2: Go to the Data Tab

Next, click on the "Data" tab at the top of the Excel window.

The Data tab contains various tools for managing your data. "Text to Columns" is among these tools, and you’ll use it to perform the conversion.




Step 3: Click on Text to Columns

In the Data tab, click on "Text to Columns" to open the Convert Text to Columns Wizard.

This wizard will guide you through the process of selecting your delimiters and previewing the result

                     


Step 4: Now, select the delimiters (like comma, whitespace, or semicolon) on this basis of which you want to split the cells data.


Step 5: You can also preview the data that how it will look after split in the Data Preview section. If everything is fine, click Next.











Comments

Post a Comment

Popular posts from this blog

ASSIGNMENT NO.5

-
Image
HOW TO USE FLASHFILL IN EXCEL Flash Fill is one of the most amazing features of Excel. It grabs a tedious task that would take hours to be performed manually and executes it automatically in a flash. And it does so quickly and simply without you having to do a thing but only provide an example of what you want. step 1:-   Enter the  First Name  in the first result cell and press  Enter . step 2:- Start  typing the next name step 3:-  Flash Fill  will suggest the  first  part of all names  step 4:-  Press  Enter . step 5:- You can see all the  First Names  in column  . step 6:- Separate the surname  Names
Read more

ASSIGNMENT NO.1

-
Image
  How to make pivot table? Creating a pivot table is a great way to summarize and analyze data in Excel or Google Sheets. Here's a step-by-step guide on how to create one: Select Your Data : Highlight the range of data you want to use for the pivot table (including headers). Insert Pivot Table : Go to the Insert tab on the ribbon. Click on PivotTable . Choose Pivot Table Location : Excel will ask if you want to place the pivot table in a New Worksheet or an Existing Worksheet . Choose one based on your preference. Click OK . Add Fields to the Pivot Table : A PivotTable Field List will appear on the right side. Drag and drop the fields (columns from your data) into one of the four areas: Rows : This will categorize your data into rows. Columns : This will categorize your data into columns. Values : This will calculate the data, like sums, averages, counts, etc. Filters : This allows you to filter the data based on certain criteria. Adjust and Cus...
Read more

ASSIGNMENT NO.2

-
Image
  R emoving duplicates in excel: The Remove Duplicates function is used to remove duplicate entries. Duplicate entries are values that two or more are the same. This can be both numbers and text inputs. A1 and A2 are duplicates since they have the same values. Select the range where you want to remove duplicate values. 1. Select Your Data: Highlight the range of cells where you want to remove duplicates. You can select a column or a table (multiple columns and rows) based on your needs. 2. Open the "Data" Tab: Go to the Data tab in the Excel ribbon at the top of the window. 3. Click "Remove Duplicates": In the "Data Tools" group, click the "Remove Duplicates" button. 4. Choose Columns to Check for Duplicates: A pop-up window will appear where you can choose which columns to check for duplicates. By default, Excel will check all columns that are part of your selected range. If you want to remove duplicates based on one specific c...
Read more