How to increment the Cell Character (alphabet) in an excel sheet

All,

I have a scenario, where in i want to increment the cell character…

Eg:
We have a cell name in an excel sheet as “A1”,now, for the next iteration,i want to make it as “B1” and “C1” and so on, basically only alphabet should increment but not the numeric.

Please suggest

Cheers!!
Ram

1 Like

there are several method to do this simple method is create a char array of A to Z and loop char array and assign the value into Read cell activity value

charArry = {A,B,C,D,…,Z}
Loop
Cell value ----> char+“1”

@SamanGuruge

Didnt worked,is it possible for you to attach the snippet…I am finding it bit confusing here.

I build a Data Table to iterate the column range. Please go through this it useful for your increment of column range.1.xlsx (7.8 KB) Main.xaml (8.5 KB)

Please refer the workflow if this is what you are looking for please update as the correct answer
loopcell.zip (11.1 KB)

1 Like

Worked fine

@SamanGuruge
Thank you

1 Like

@vamsiyeluri

This worked fine and handy as well, Thanks :grinning:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.