How to copy a cell content without new line

When copying an Excel cell content with Ctrl + C, a new line (hidden character) will append automatically at the end of the copied content as below screenshot shown.

 If you want to use the cell content in the next action or plugin as a variable, you have to remove the new line break character. Please, do as follows.

Step-by-step guide

1. Create a user variable to save a cell content, Settings > User variable in Scenario .
   I defined '{{g1,v1}}'.

   
   

2. Select a cell you want to copy the content. You can use 'LocateImage' like this example.
   
   
   
   
3. Select 'X2 (double click)' in 'Click Type'
   
   
   
   
4. Add 'ShortcutKeys' and add key sequences, Home, LShift + End, LCtrl  + C. Of course, you can use RShift + End and RCtrl + C instead.
   
   
   

5. Add 'SetVariables' and set 'Clipiboard' value to your previous defined variable, 

   
   
   

Sample Bot

• Bot: sample-excel01.zip

• Data: sample-excel01.xlsx

Build on

• STU: R19.0723
• PAM: R19.0603

Prerequisite for running this bot

• Excel
• Notepad

How to run this bot

1. Download and save a sample bot / excel file
2. Run STU
3. Select 'File > Import' and choose a download bot .
4. Run your own Excel and open the sample excel file
5. (Option) Capture a screenshot for LocateImage
6. Run Notepad
7. 'Run > Test Run' in STU

Related articles

• Benny's Secret Functions