Showing posts with label CONCATENATE. Show all posts
Showing posts with label CONCATENATE. Show all posts
Tuesday, 17 March 2020
Saturday, 7 March 2020
CONCATENATE
CONCATENATE
Joins several text items into one text item
Category : Text
Location : Built-in
 |
| Concatenate |
What Does It Do?
This function joins separate pieces of text into one item.
Syntax
=CONCATENATE(Text1,Text2,Text3...Text30)
Up to thirty pieces of text can be joined.
Formatting
No special formatting is needed, the result will be shown as normal text.
Note
You can achieve the same result by using the " & " operator.
 |
| Concatenate_1 |
Watch Video Click For More Details
Please Subscribe the Channel for more Excel formulas and VBA Macro Codes
Subscribe to:
Posts (Atom)
-
OFFSET function And the Sum formula About : To calculate the total of a specific group of months the =OFFSET() function has been used. ... -
INDEX Function About : Uses an index to choose a value from a reference or array Category : Lookup Location : Built-in ... -
HLOOKUP Formula About : Looks in the top row of an array and returns the value of the indicated cell Category : Lookup Locat...
