Assignment no.6 Text to column in excel

 

Text to Columns in Excel

 

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.

STEP 1. Select the range with full names.


STEP 2. On the Data tab, in the Data Tools group, click Text to Columns.


STEP 3. Choose Delimited and click Next.


STEP 4. Clear all the check boxes under Delimiters except for the Comma and Space check box.


STEP 5. Click Finish.

Comments

Post a Comment

Popular posts from this blog

Assignment no.7 Use of vlook formula in exvel

Image
  VLOOKUP VLOOKUP works by searching down the first column of a table to find a match. Once it locates that match, it retrieves data  from the specified column of the same row.  FORMULA: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])                                       Step 1:LOOKUP VALUE                             The lookup value S elect the cell where you want the result to be and start the VLOOKUP formula by typing: STEP 2 : Table array   Now Excel asks you to write the second argument into the VLOOKUP function: the  table_array . This range must contain both the column you’re looking in and the column you want to return something from. Step 3: Column index number The third argument of the VLOOKUP syntax is the  col_index_num  (column index number). The colum...
Read more

Assignment no.4 Filtering in ms excel

Image
  Filtering in MS Excel helps you narrow down your data to show only the information you need. Here's how to use it: *Types of Filters* 1. *AutoFilter*: Automatically filters data based on the column headers. 2. *Advanced Filter*: Allows you to filter data using complex criteria. 3. *Custom Filter*: Enables you to filter data using custom criteria. * How to Apply Filters* 1. Select the range of cells you want to filter. 2. Go to the "Data" tab. 3. Click "Filter" in the "Data Tools" group. 4. Select the column header you want to filter. 5. Choose the filter type (e.g., "Number Filters" or "Text Filters"). 6. Select the filter criteria (e.g., "Greater Than" or "Contains"). 7. Click "OK" to apply the filter . *Filter Options* 1. *Number Filters*: Filter numbers based on criteria like "Greater Than," "Less Than," or "Between." 2. *Text Filters*: Filter text based on criteria li...
Read more

Assignment no.3 Data validation in excel

Image
  Data validation in Excel helps ensure accuracy and consistency in your data. Here's how to use it: *Types of Data Validation* 1. *Whole Number*: Restrict input to whole numbers within a specified range. 2. *Decimal*: Restrict input to decimal numbers within a specified range. 3. *Date*: Restrict input to dates within a specified range. 4. *Time*: Restrict input to times within a specified range. 5. *Text Length*: Restrict input to a specific text length. 6. *List*: Restrict input to a list of predefined values. 7. *Custom*: Create a custom formula to validate input. *How to Apply Data Validation* 1. Select the cell(s) you want to validate. 2. Go to the "Data" tab. 3. Click "Data Validation" in the "Data Tools" group. 4. Choose the validation type from the dropdown menu. 5. Set the validation criteria (e.g., minimum and maximum values). 6. Click "OK" to apply the validation. *Additional Options* 1. *Input Message*: Display a message when a u...
Read more