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)
Concatenate in MS Excel and most of other tool is function to join text.
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)
Normally yes, but it will actually take numbers and combine them into a text string.
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)
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"
numbers and text
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.
number instead of a letter (text)
Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.
A possible answer is text, numbers, and special characters.
Start your entry with an apostrophe (') to indicate the cell contents is text.
A column break is a term associated with Microsoft Word, not Excel. In Word, it starts a new column of text. In Excel, you can just go to another column to start entering new data.