Excel CONCATENATE Function (Example + Video)
When to use Excel CONCATENATE Function
CONCATENATE function can be used when you want to join 2 or more characters or strings.
What it Returns
It returns the joined text.
Syntax
=CONCATENATE(text1, [text2], …)
Input Arguments
- text1 –Â the first item to join. The item can be a text value, number, or cell reference.
- [text2], .. –Â Additional text items to join. It can handle up to 255 items, up to a total of 8,192 characters.
Additional Notes
- Can join a maximum of up to 255 text strings into one text string.
- Can be used to join text, numbers, cell references, or a combination of these items.
Excel CONCATENATE Function – Live Example
Excel CONCATENATE Function – Video Tutorial
Related Excel Functions:
- Excel LEFT Function.
- Excel LEN Function.
- Excel MID Function.
- Excel REPT Function.
- Excel RIGHT Function.
- Excel TEXT Function.
- Excel TRIM Function.
You May Also Like the Following Excel Tutorials:
A
B
C
Join with sperator
D
E
F
G
Join with sperator
I want join in one formula at one time or drag pls guide