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 office 2019 or higher versions and office 365 online Syntax =concat(cell 1, cell 2, cell 3, … cell n) Where

  Tamizh Tech Tutorial Excel Tips - How to add New Line in Cell                 In this tutorial, you will learn how to add new line in excel using shortcuts. Steps Select the target cell and go to the formula bar. Type word and press Alt+Enter key if you need a newline and press ok. Result Before Update Select the target cell and type the word Expand the formula bar, Press Alt + Ctrl when you need a new line, then the formula bar will add the new line automatically like the screenshot below Result After Update