Shift values from right to left

Help
, ,
1

i want to shift values from right to left in excel in uipath

1 Like
2

@Ananya1 Could you please explain much more?

3

Shift

I want to shift values
i want output like Capture capture screenshot

4

Hi
Use start process activity and and mention the file path of excel as input to Filename property
—then use a send hot key activity with key as ctrl+g
—then use type into activity and type as “C2”
—then use a send hot key activity with key as ctrl+end
—now use another send hot key activity with key as ctrl+x
—and one more send hot key activity with key as ctrl+g
—now use type into activity with input as “B2”
—and finally a send hot key activity with key as ctrl+v

Cheers @Ananya1

5

Hello @Ananya1
You can do method suggested by Palaniyappan using hotkeys or you can use LinQ here…

Check the below workflow for better understanding

Lefttoright_Linq.xaml (9.0 KB)

1 Like