How to copy a cell content without new line

Owned by Seongho Jang (Unlicensed)
Last updated: Dec 16, 2021


hen 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.
    Click "click here to add a new row" and  type "GroupName" & "VariableName". 
    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.

    Now, your cell data is selected and copied to clipboard.


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