Hi Mike,
Formulae cannot replicate formatting - only values. What you could do is to copy the range, paste it into Word as a table, then convert the table to text with, say, spaces as the separators. That will preserve your formatting.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|