How can i concatenate excel rows without using macro
For example :
I need to concate email column based on First name and Last name Columns
The output should be like this :
How can i concatenate excel rows without using macro
For example :
I need to concate email column based on First name and Last name Columns
The output should be like this :
You should simply have to insert a NewLine from the String package. Using this as an example file:
I set up the following test steps:
The result:
While this isn’t exact to the process you are using, it should give you enough to go on to accomplish what you are after,
Select the cell where you want to put the combined data.
Type = and select the first cell you want to combine.
Type & and use quotation marks with a space enclosed.
Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.
Select the cell where you want to put the combined data.
Type =CONCAT(.
Select the cell you want to combine first.
Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text.
Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT(A2, " Family").
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.