answersLogoWhite

0

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)

User Avatar

Wiki User

10y ago

What else can I help you with?

Related Questions

What is concatenate?

Concatenate in MS Excel and most of other tool is function to join text.


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)


Does the CONCATENATE function in Excel require a text argument?

Normally yes, but it will actually take numbers and combine them into a text string.


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)


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"


What are examples of types of data in Microsoft Excel?

numbers and text


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.


In Microsoft Excel what is the meaning of Numeric?

number instead of a letter (text)


Can a person complete calculations in Microsoft Excel 2003?

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.


What are characters called in Microsoft Excel?

A possible answer is text, numbers, and special characters.


What do you place to the left of an equals to get text in Microsoft Excel?

Start your entry with an apostrophe (') to indicate the cell contents is text.


What is column break in Microsoft Excel?

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.