Tamizh Tech Tutorial

  Tamizh Tech Tutorial Word Frequency in Excel           In this tutorial, you will learn and find how to count words in excel. Follow the steps below Step 1: Extract the input words using unique function =unique (input range) Step 2: Apply the builtin formula named countif (range, condition) for the obtained unique words using unique() function from step 1 Display the result. Example - Word Count in Excel 1. Input 2. Extract the unique words using unique() =UNIQUE ( H11:H26 ) 3. Result =COUNTIF ( H11:H26 , I11 ) The function above is used to display the word frequency based on the condition. Tamizh Tech Tutorial

  Tamizh Tech Tutorial 4 Tips to Merge Cells in Excel                 Excel Tutorial In this tutorial, you will learn 4 excel tips to merge cells in excel with example. Excel Tips - 4 Tips to Combine Cells in Excel  Using Concatenate(cell 1, cell 2, ...celll n) function Using Concat(cell 1, cell 2, ...cell n) function Using & Operator Using TextJoin(delimiter, ignore_empty, cell 1, cell 2,  cell n) 1. Using Concatenate(cell 1, cell 2, ...cell n) It is a predefined excel function  This function is used to merge /join multiple cells into single cells. Syntax =concatenate(cell 1, cell 2, cell 3, … cell n) Where, cell 1, cell 2, cell 3, … cell n are list of input cells. 2. Using Concat(cell 1, cell 2, ...cell n) It is a latest predefined excel function  Like Concatenate() function, this function is used to merge /join multiple cells into single cells. Note It is available in offic...