Removing line break from exel with blue prism,

Digital_WorkerB — Mon, 26 Aug 2019 20:01:00 GMT

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.

topic Removing line break from exel with blue prism, in Digital Exchange

Removing line break from exel with blue prism,