excel CONCAT

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 »

Excel Concat Function

This post will guide you how to use Excel CONCAT function with syntax and examples in Microsoft excel. Description The excel CONCAT function combines 2 or more strings or ranges together. This is a new function in Excel 2016 and it replaces the CONCATENATE function. However, the CONCATENATE function is still available for earlier version… read more »