View Single Post
 
Old 03-28-2019, 11:30 PM
Chibiberu Chibiberu is offline Windows 7 64bit Office 2013
Novice
 
Join Date: May 2014
Location: Japan
Posts: 11
Chibiberu is on a distinguished road
Default Need ca macro to remplace all line breaks inside all cells

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
Reply With Quote