Excel CONCAT

Concatenate columns with Line Breaks (Alt + Enter)

This post will guide you how to combine multiple cells in one or more columns into one cell with line breaks or Alt +enter in Excel. How do I concatenate different values together into one cell with line breaks. For example, if you are trying to combine three cells (B1,B2,B3) into one(C1) with line breaks… read more »

How to Add Prefix or suffix to Cell

This post will guide you how to add common prefix or suffix to all cells or the range of cells in your worksheet in Excel. How do I add the same prefix or suffix to a range of cells without any changing the existing numbers or text in the range. How to add prefix or… read more »

Highlight Duplicate Rows

This tutorial will teach you how to highlight duplicates rows using conditional formatting feature in Excel. In the previous post, we talked that how to change the color of rows based on a certain number or text or begin a specific character in a specified column. And this post will talk that how to highlight… read more »

How to Combine 3 Cells to Generate One Date

This post explains that how to create a date from 3 different cells in excel. How do I combine 3 general cells to one date cell using excel formula. Assuming that you have a list of data that contain three columns of data naming: year, month and day. You want to generate a date from… read more »

How to insert leading zeros to number or text

This post explains that how to insert or add leading zeros in front of a number or text string in excel. How do add the leading zero to the front of the number using Text function in excel. Add leading zeros to number or text If you have a list of zip codes or employee… read more »

How to add text to the end all cells

In the previous post, we talked that how to add the same text into the beginning of the text in one cell or all selected cells. And this post will guide you that how to add the specified text or characters to the end of all cells in excel. How to create an excel formula… read more »

How to add text to the beginning of all cells

This post explains that how to add the specified text or characters to the beginning of all cells in excel. How to create an excel formula to add same text string or characters to the beginning of text string in one Cell. How to create an excel macro to add specific text to the beginning… read more »

How to combine columns without losing data

This post will guide you how to merge and combine multiple columns without losing any data in excel. How do I merge columns without losing data using Excel Formula. For example, you want to join two columns that contain first name and last name into one column without losing data. If you want to merge… read more »

How to Combine Text from Two or More Cells into One Cell

This post explains that how to combine text from two or more cells into one cell in excel. How to concatenate the text from different cells into one cell with excel formula in excel. How to join text from two or more cells into one cell using ampersand symbol. How to combine the text using… read more »

Excel Nexted IF Functions (Statements) Tutorial (15 IF Formulas examples)

This tutorial will guide you how to use nested Excel IF function¬† (include multiple If statements in excel formula) with syntax and provide about 15 nested IF formula examples with the detailed explanation in Microsoft excel. Nested If function Description Nested If Function Syntax Examples of Nested IF function in Excel Nested If Functions(Statements) Order… read more »

Sidebar