Hi,





I am totally novice in Excel macros and VBA.



I download every day an Excel file from a web site In this file, almost all cells contain 2 data separated by a line break.
I need to change all these line breaks in order to go on on my work, but I cannot do it manually because there are thousands.



So, I want to create a macro that will change all line breaks in all cells to a semicolon character (or just deleting all line breaks will be fine too). But I don't know how to do it. Many thanks in advance for any help.


I use Office Excel 16.24 (Office 365) on MacOS