I would like the space characters to disappear to the left of the "|" and i would like to delete "{***}"
for example, I have such a text in the worksheet. The problem is that it's 5000 lines.
dlga_start:blocked_agent |This person seems busy. Maybe I should move on...{***}
the text in the rows may have a different number of columns compared to the others.
should look like: dlga_start:blocked_agent|This person seems busy. Maybe I should move on...
how to solve this problem the easiest way?
(with the exception of manual correction)
Bookmarks