Question

How to Concate excel rows without using macro ?

  • 12 January 2023
  • 2 replies
  • 31 views

Badge

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 :

 


2 replies

Badge +6

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:

  • Excel (Advanced) Open
  • Get single cell - C2 > output to variable $firstRow
  • Get single cell - C3 > output to variable $secondRow
  • String Assign - $firstRow$$String:NewLine$$secondRow$ to variable $lineOutput$
  • Set cell - C10 $lineOutput$

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,

Userlevel 4
Badge +9

@sree 1855 

Combine data with the Ampersand symbol (&)

  1. Select the cell where you want to put the combined data.

  2. Type = and select the first cell you want to combine.

  3. Type & and use quotation marks with a space enclosed.

  4. Select the next cell you want to combine and press enter. An example formula might be =A2&" "&B2.

Combine data using the CONCAT function

  1. Select the cell where you want to put the combined data.

  2. Type =CONCAT(.

  3. 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.

  4. Close the formula with a parenthesis and press Enter. An example formula might be =CONCAT(A2, " Family").

Reply