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]

Hi Paul,

if it works, this is the solution ! But how do I convert a table in Word, with spaces, into a sentence (= text) ??? This would be it !

Thanks,

Mike