Skip to main content
Cadet | Tier 2
March 14, 2025
Solved

AA360 Community Edition - Simulate keystrokes not opening Replace window in Excel

  • March 14, 2025
  • 3 replies
  • 116 views

I want to clean data in a csv file by opening it in excel and using replace to remove known extraneous characters. I have tried:

and

However, both just resize the excel window? 

Best answer by Marc Mueller

Hi ​@esheridan,

Try with lowercase h with your version 1. ☺️

Maybe you need also increase the delay between keystrokes.

 

Cheers

Marc

3 replies

Marc Mueller
Most Valuable Pathfinder
Most Valuable Pathfinder
March 14, 2025

Hi ​@esheridan,

Try with lowercase h with your version 1. ☺️

Maybe you need also increase the delay between keystrokes.

 

Cheers

Marc

🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
esheridanAuthor
Cadet | Tier 2
March 14, 2025

thanks!! ​@Marc Mueller 

Marc Mueller
Most Valuable Pathfinder
Most Valuable Pathfinder
March 14, 2025

Glad it helped!

 

Cheers

Marc

🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy