E
Ed
I am using Convert Text to Table on a large amount of text. The table will
have over 14,000 rows. When the text is pulled into the doc, the code grabs
a certain number of character spaces, even if they're empty. It's not safe
to just Find/Replace three consecutive spaces with one space until Execute =
False. These unwanted spaces will always show up, though, as leading or
training spaces in the table cells after conversion.
Is there an easy way to delete all leading or trailing spaces in every table
cell?
Ed
have over 14,000 rows. When the text is pulled into the doc, the code grabs
a certain number of character spaces, even if they're empty. It's not safe
to just Find/Replace three consecutive spaces with one space until Execute =
False. These unwanted spaces will always show up, though, as leading or
training spaces in the table cells after conversion.
Is there an easy way to delete all leading or trailing spaces in every table
cell?
Ed