Microsoft Office Forums - View Single Post - How to combine the texts of all cells in a column without line break.

Thread: How to combine the texts of all cells in a column without line break.

View Single Post

Old

03-29-2022, 05:28 PM

ericliu24

ericliu24 is offline

ericliu24 uses Windows 10

Windows 10 ericliu24 uses Office 2019

ericliu24 uses Office 2019

Office 2019

Novice

The original poster

Join Date: Mar 2022

Location: China

Posts: 21

ericliu24 is on a distinguished road

Default

This fixed it.

.Range.Text = Replace(String1, vbCr, "")

Reply With Quote