![]() ![]() It is easiest to demonstrate the usefulness of this function by using an example. ![]() ![]() In Excel, the concatenate formula can literally save you days of work and frustration. Although the word has possibly been in use since the late Middle Ages, its use in computer languages over the last decades has escalated its status and prevalence across different platforms. Test your Excel skills with the corresponding FREE Online Multiple ChoiceĬoncatenate Function, Convert Text to Columns & Remove Duplicates Excel TestĪccording to the Oxford Dictionary the word concatenate means to link things together in a series. Excel even has a built-in function to remove duplicate values to ensure your data is free from repeat entries. The converse function of concatenate is the Text to Columns function which allows you to separate text across different columns. Use the concatenate function to combine words and even numbers that are contained across different columns into one cell. Sometimes you need to combine the contents of different cells into one, sometimes you need to split the data in a cell into separate cells. Free Excel Tutorial – Concatenate, Convert Text to Columns & Remove Duplicates – Excel 2010 Concatenate Function, Convert Text to Columns & Remove Duplicates Excel Tutorialįree Online Microsoft Excel Tutorial * How to Use the Concatenate Function
0 Comments
Leave a Reply. |