I would like to paste a link to cell B into cell A as a hyperlink, while keeping the text ‘1 2 3 4 5 6’ in cell A unchanged. Is there a way to overwrite only the URL while preserving the text? Thank you in advance!
Need more information. Could you provide the expected output you are looking for?
1 Like
For Each Row
Input: YourDataTable
Output: row (System.Data.DataRow)
Assign
To: row(“CombinedColumn”)
Value: row(“Column1”).ToString + " " + row(“Column2”).ToString
1 Like
@vkalra
I have read it, but I still don’t understand. Could you provide the code with a screenshot, if possible
@devasyasingh
Is this what you’re saying?
News_3.xlsx (9.9 KB)
@Moulika_Kaviti
Thank you so much. Could you provide the code with a screenshot, if possible?
there is another way
read the excel from column B1
write it into another excel
@Moulika_Kaviti
Thank you so much!
Could you please provide the ‘assign’ code?
Assign
To: row(“CombinedColumn”)
Value: row(“Column1”).ToString + " " + row(“Column2”).ToString
in row place you can use currentrow of for each row
1 Like
@Moulika_Kaviti
Thank you so much!
Assign
To: row(“B1”)
Value: row(“A1”).ToString + " " + row(“A20”).ToString
Is this the right way?
combined columns means where you need to combine that column either A/B/C…
column1 is A column2 means
1 Like
You would have to use write cell acitivity inside any loop:
by giving cell value as “A”+(index+1).ToString and cell value as:
“=Hyperlink(B”+(index+1).ToString+“,A”+(index+1).ToString+“)”
Thanks,
Aditya
Thank you so much. Could you provide the code with a screenshot, if possible?
I already gave you the logic. Won’t be able to provide a screenshot.
I’m Away From Keyboard.
It’s pretty easy.
Just follow the steps and logic written above
1 Like
sharazkm32
ashokkarale
V_Roboto_V
Anil_G
adilhassanpost
Hosam_Alzahrani
gorby
Sreekumar_Sedharth
adi.mehare
stary