Need to apply concatenate formula in an excel with 50,000 rows

Help Studio
1

Hi Team,

I need to apply concatenate forum on a column 8

Formula is (=Concatenate(A2,B2,C2,D2,E2,F2))

If i use for each row it is taking time. Is there any other alternative way in LINQ to apply formula

Thanks,
Ula

2

@Boopathi

Use Invoke Method activity to do this. Please check below thread for your reference.

3

In your Excel workbooks, Often you may want to split the content of one cell into individual cells, or do the opposite - combine data from two or more columns into a single column.

Step by step Excel Formula video - click
Step by step full Excel guide video - click

In Microsoft Excel, & operator is another way to concatenate cells. This method come in very handy in many scenarios because typing the ampersand sign (&) is much quicker than typing the word “concatenate” :slight_smile:

Similarly to the CONCATENATE function, you can use " & " in Excel to combine different text strings, cell values and results returned by other functions.

Excel CONCATENATE function

The CONCATENATE function in Excel is designed to join different pieces of text together or combine values from several cells into one cell.

Concatenating the values of several cells

The simplest CONCATENATE formula to combine the values of cells A1 and B1 is as follows:

=CONCATENATE(A1, B1)