Combining Text from Table Cells
Hi, I am a new forum member but an old and limited user of MSOffice.
I have a series of tables in a Word template used to record comments.
I would like to select the text in column 2 for each of the rows and stitch it together in a string for out put in another document.
I am effectively using the command
ActiveDocument.Tables(2).Cell(Row:=2, Column:=2).Range.Select
to select the text and
StitchText = StitchText + Selection
to put the text together but am getting a carrigae return or similar at the end of each Selection.
I think this is part of the Cell information retrieved by the Range.Select command but it could be anything.
Please can you suggest a fix or better method for combining all the cells text in to one?
Thank you.
|