answersLogoWhite

0

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

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

A Write the algorithm to concatenate two given strings?

a write the algorithm to concatenate two given string


What is concatenate function in c?

strcat


What is concatenate key in a relational database?

The concatenate key is simply the combination of several columns in a table, which serves the unique key of that table.


What character allows you to concatenate strings in PHP?

To concatenate strings in PHP, you use the . (dot) character. For example: $str = "String1" . "String2";


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)


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 concatenate a string?

v can concatenate two string by using a function like: select CONCAT( CONCAT('ename','e_mrks'),"name","marks" from student;


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)


Synonyms for unite?

Join. Concatenate. Combine. Merge.


How do you join the text in two cells together in a spreadsheet?

You can use the Concatenate function or the & operator. Both of the following will result in the same thing: =CONCATENATE("abc","def") ="abc" & "def"


What is the cat command in perl?

The concatenate operator in perl is a period, ie .


What to do with two peaces of normal string?

Whatever you want. Concatenate them, for example.