0
Normally yes, but it will actually take numbers and combine them into a text string.
Wiki User
∙ 8y ago
Add your answer:
Earn +20 pts
What is concatenate?
Concatenate in MS Excel and most of other tool is function to join text.
Where do you go in Excel to concatenate?
Concatenating is joining bits of data together, like two separate pieces of text into one piece. There is a function called CONCATENATE or you can use the & symbol. Both of these will do the same thing: =CONCATENATE( "ABC" , "DEF" ) ="ABC" & "DEF"
How do you add text together in Excel cell?
You can concatenate text either using the CONCATENATE function or the & operator. If you had text in cell A2 and cell B2 that you wanted to add together in another cell you could do it in either of these ways: =A2 & B2 =CONCATENATE(A2,B2)
How do you concatenate text in Microsoft Excel?
You can concatenate using the & operator. So say you have a firstname of a person in cell B2 and their surname in cell C2 and in D2 you want to display their first name, a space and their surname together, you would do this: =B2 & " " & C2 You could also use the CONCATENATE function to do the same thing: =CONCATENATE(B2," ",C2)
What is the maximum number of text items that you can join into a single text item using the concatenate functions?
If you used the CONCATENATE function then there's a limit to the number of arguments which is Excel version dependent. Excel 2007 and newer versions allow 255 arguments, all older versions allow 30 arguments. You don't need to use the CONCATENATE function. You can use the & operator to concatenate instead. =A1&", "&B1&", "&C1 Using this method you're only limited by the allowable maximum length for a formula which, again, is version dependent. Excel 2007 and newer versions allow 8192 characters, all older versions allow 1024 characters. You could also concatenate the results of several concatenate formulas in a new formula.
Which term describes a function used as an argument for another function?
In Excel a function within another function would be called a nested function.
What is concatenating in Microsoft Excel?
Concatenate means to join text together. You can do this using the & operator. So say you have a firstname of a person in cell B2 and their surname in cell C2 and in D2 you want to display their first name, a space and their surname together, you would do this:=B2&" "&C2You could also use the Concatenate function to do the same thing:=CONCATENATE(B2," ",C2)
When the function argument box appears in excel?
When you choose the Insert Function command and then pick a function to use, it will appear so that you can type arguments into it.
What are arguments in MS Excel?
Arguments are the values that are entered into functions to enable them to work. Most functions require arguments. For example, if you want to find out what day of the week a date is, you need a function called Weekday and the date that you want as the argument of the function.
What is a argument in Microsoft Excel?
An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.An argument is the name for something used in a function in order for it to work. A SUM function needs something to sum, so you provide that. That is an argument. Most functions require arguments to work, though there are some, like TODAY() that don't need any arguments.
What does Excel do if you do not include an optional argument?
If you do not include an optional argument, Excel will use the default value for that argument.
How do you merge multiple cells containing multiple date in excel?
If you merge cells into one cell, the data from the first cell is retained and all other data in the other cells is lost. To get data from lots of cells into another cell you can concatenate them, using the & or the CONCATENATE function. So to combine the contents of cell A1 and B1, to be shown in C1, you could do this: =CONCATENATE(A1,B1) or =A1&B1 To put a space between the contents of the two cells then you would change it slightly, like these: =CONCATENATE(A1," ",B1) =A1&" "&B1
