Append Text to clipboard and paste

I'm trying to create a macro that:

  1. Copies a field in Excel
  2. Moves 2 spaces to the left
  3. Appends the text I specify to the clipboard data and pastes it in a new field

When I run the macro it only pastes the copied data with no appended text.
In the example it should be pasting "My Text23" (if 23 was copied to the clipboard).

Here's what I have:
Screen Shot 2020-05-18 at 7.55.45 AM

Any ideas?

Append to Clipboard and Paste.kmmacros (3.2 KB)

I also tried setting it to this:

Screen Shot 2020-05-18 at 8.37.42 AM

Also tried using a named clipboard:

Screen Shot 2020-05-18 at 9.22.03 AM

Use a Named Clipboard.kmmacros (4.0 KB)

The strange thing is if I use "Display Text In A Window" it gives me the desired result:

Screen Shot 2020-05-18 at 9.35.43 AM

Screen Shot 2020-05-18 at 9.35.35 AM

Change it to this:

Screen Shot 2020-05-18 at 9.36.44 AM

or this:

Screen Shot 2020-05-18 at 9.38.12 AM

And this is the result:

Screen Shot 2020-05-18 at 9.37.07 AM

I found a workaround by showing it in the window, selecting all and then copying, hitting enter to close the window and THEN moving and pasting The problem is that it's reformatting the text with a different font now. . It shouldn't be this difficult :slight_smile:

[EDIT]

Testing this it only works half the time. I've tried putting pauses in but it's finicky...

Screen Shot 2020-05-18 at 9.46.28 AM

I figured out a way to do this. It was the "Paste" command that was messing things up. When I switched to "Type" it worked. Also the Repeat on the arrow keys was glitchy. I had to do single versions of those.

I added a user input at the beginning to keep it configurable. I'm posting it here for any one who wants it :slight_smile:

Screen Shot 2020-05-18 at 12.02.59 PM