How to use concatenate function in Excel | How to join Text or Numbers using concatenate function.

Показать описание

#MsExcel #Concatenate #Jointext

Worried about how to save the time from typing the contact numbers and country name in a fresh column?

Not anymore. Concatenate function helps you to join two text or two numbers from different column. Concatenate function can join upto 30 characters. You can bring in any number of characters.

Be it " ?", "/", "\", "&", "*". Any number of characters can be inserted while concatenating the string.

Date , workday, vlookup, transpose and many other functions can be texted in concatenate function. It saves lots of your time eliminating the non-value activities.

Three activities are covered in this video

1. Join the Numbers ( country code and mobile number)
2. Join two text (First name and last name)
3. Join text and date (To complete a sentence)

Keep Watching,Keep Learning.

-~-~~-~~~-~~-~-
Please watch: "How to Use Concatenate With Vlookup in Excel "
-~-~~-~~~-~~-~-