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 JMarinoView original
LOL answered my own question. Totally forgot there’s a $String:Enter$ variable that we can use!