Copy columns and paste in same excel and count the no of words in column and add count

Help Activities
, , , , , ,
1

Hi all,

I am stuck in below

Input excel has 55 column
out of that we need to copy data from 2 columns and add to other column as it is
data to be copied from NAME and EMPID copied to already existing blank column names- EMP_NAME and EMP_EMPID
also, in one of the column there is data words separated by semicolon , we need to count it , how many words, we can also count semi columns . bot should add count column at end.
Sample.xlsx (10.3 KB)

TIA !

2

@Nidhi_Gupta1,

Thanks for the context and details but what’s the exact issue you re facing?

3

@ashokkarale
thanks for reply
file has more than 3000 rows, Wish to use linq and not for each
I am learning linq but not expert yet

4

Hey,
Why not try connecting Excel as a database to update the required data? It’s faster than Excel automation, requires fewer activities, and makes code management more efficient.

Please find the screenshot below along with the attached sample file.

image
image616×256 6.83 KB

UpdateColumnUsingExcelAsDB.xaml (7.6 KB)

1 Like