macro to remove carriage returns in excel for mac

Ro To Remove Carriage Returns In Excel How To Go About

For a better experience, please enable JavaScript in your browser before proceeding.

Does anyone such a macro Obviously find and replace does not work.

But STRGEnter could be wrong, try ALTEnter, still this removes only Char 10 - a line feed and not a Carriage Return Char 13.

Its character 13 Im trying to remove as the following formula works on a single cell.

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

I am familiar with Macros and VBA in Excel but have never used it in Word and not really sure where to start.

Ro To Remove Carriage Returns In Excel How To Go About

I have a feeling this will be relatively easy but I have no idea how to go about it.

What I am looking for is a Macro that will scan each character in the document.

If that character is a Carriage Return AND the next character is also a Carriage Return then delete one of them.

Thanx a million in advance for your help This dosument is over 3,000 pages long, and rather than letting Word wrap the text and double space it, the freaking genius that wrote hit enter twice at the end of every line.

If your documents creator used 3 paragraph breaks, for example, to delineate paragraphs, you will lose that delineation.

After cleaning up the paired paragraph breaks used for the double-spacing, you might be interested in cleaning up even the unnecessary single paragraph breaks with the macro in this thread.

Macro To Remove Carriage Returns In Excel For Mac