Microsoft Office Forums - View Single Post - remove carriage return

Thread: remove carriage return

View Single Post

Old

04-04-2019, 01:38 PM

abenitez77 abenitez77 is offline

abenitez77 is offline

abenitez77 uses Windows 10

Windows 10 abenitez77 uses Office 2016

abenitez77 uses Office 2016

Office 2016

Novice

The original poster

Join Date: Apr 2019

Posts: 9

abenitez77 is on a distinguished road

Default

I just figured it out...I just did these 2 lines:

Code:

Sheets(1).Cells.Replace What:=Chr(10), Replacement:=" "
Sheets(1).Cells.Replace What:=" ", Replacement:=" "

Last edited by abenitez77; 04-05-2019 at 04:45 AM.

Reply With Quote