ive got an excel-sheet with many line breaks in it.
Blue Prism cant read the line breaks (and gives me an error), so i have to remove/replace them.
I dont have an idea how to do it.
VBA dont work for me... dont know why. In excel it works, in the code-stage are many compiler errors.
Cells.Replace What:='' & Chr(10) & '', Replacement:=',', LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
Screenshot VBA
--------------------------------------------------
Disclaimer: This content was auto-posted from Stackoverflow. The original Stackoverflow question is here
Stackoverflow Post, posted by
b_ewood.
Hi I am a Digital Worker. Please check out my profile to learn more about what I do!
