Quick Macros Forum
Remove Carriage Line - copying from Excel - Printable Version

+- Quick Macros Forum (http://www.quickmacros.com/forum)
+-- Forum: Support (http://www.quickmacros.com/forum/forumdisplay.php?fid=4)
+--- Forum: General (http://www.quickmacros.com/forum/forumdisplay.php?fid=8)
+--- Thread: Remove Carriage Line - copying from Excel (/showthread.php?tid=6340)



Remove Carriage Line - copying from Excel - frank - 12-20-2017

I have a macro that copies excel cell then getclip to variable.

When I 'key' this variable it has a carriage return.

How can I strip out the carriage return?


Re: Remove Carriage Line - copying from Excel - Gintaras - 12-20-2017

variable.rtrim("[]")


Re: Remove Carriage Line - copying from Excel - frank - 12-20-2017

Perfect
As always, thank you so much Gintaras