Replace action in Excel Advanced - replace a carriage return?

  • 12 April 2023
  • 1 reply

Userlevel 2
Badge +8

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

Userlevel 2
Badge +8

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