Replace action in Excel Advanced - replace a carriage return?

  • 12 April 2023
  • 1 reply

Badge +5

I need to do some cleanup in an excel sheet where there are carriage returns in some of the cells. I want to remove the carriage returns so that I can then put the entire sheet into a data table.

Has anyone ever tried to do this using the Replace action in Automation Anywhere? If so, how did you do it? In Excel you can search for carriage returns by using Find/Replace and by typing Ctrl+J in the find box.


Best answer by JMarino 12 April 2023, 18:25

View original

1 reply

Badge +5

LOL answered my own question. Totally forgot there’s a $String:Enter$ variable that we can use!