Changing:
.End = .End - 1
to:
.End = .End - 2
indicates you have some extraneous content between the 'find' expression and the end-of-cell marker. A space or paragraph break, perhaps?
As for:
Quote:
|
there is a little final problem: The replacement text keeps the column formatting (which I don't want).
|
I did warn you:
Quote:
|
The drawback with this approach is that the format of the replacement will be the same as whatever is in the table.
|