View Full Version : Remove line breaks
mikke3141
12-09-2014, 09:19 AM
Hello,
I'm trying to load the attached csv file to excel with vba, but there are hidden page breaks that split the rows. How can I load file so that the page breaks are removed?
Thank you for your help.
Hi..
What are you expecting as the result..? it is not clear to me.
For example.. if you use:
x = Replace(Join(Application.Transpose(Range("A1").CurrentRegion), Chr(12)), Chr(12), "|")
You will see a string that has all your Page Breaks replaced with the Pipe character.. and that there was a Page break after each cell.. so which ones are the hidden ones that you want removed..?
mikke3141
12-23-2014, 12:48 AM
The page breaks that are in the line end should remain, but those that are inside the row (excel misinterprets them to page breaks) should be removed.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.