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

		Microsoft Office Forums > Microsoft Word > Word VBA
How to combine the texts of all cells in a column without line break.

03-29-2022, 05:28 PM

ericliu24

Windows 10 How to combine the texts of all cells in a column without line break.

Office 2019

Novice

Join Date: Mar 2022

Location: China

Posts: 21

This fixed it.

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Table styles - First column shading with bottom line on page break	NicB	Word Tables	2	02-20-2019 03:05 AM
Organise cells with line break into separate rows	vjvj123	Excel Programming	6	09-26-2018 09:19 AM
Word converts section break to page break before columns, does not insert column breaks	eborda	Word	1	03-24-2017 11:06 PM
Interchange line break and paragraph break shortcut keys	skan	Word	2	01-20-2017 03:50 AM
How to automatically insert a line after a Column Break	YooperNC	Word	3	01-29-2015 07:16 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:34 PM.