|
|
#4
12-06-2011, 02:05 AM
|
||||
|
||||
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] 
|
| Tags |
| concatenate w/ format |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel copy formula | KMS | Excel | 1 | 08-16-2011 03:02 PM |
 need to check whether cell contains formula
|
etodem | Excel | 2 | 10-23-2010 07:33 PM |
|
Formula in a Cell with condition?
|
Learner7 | Excel | 1 | 07-19-2010 10:10 AM |
|
Protect formula in cell?
|
markg2 | Excel | 4 | 05-24-2010 11:50 AM |
| Excel error: "Too many different cell formats" | enviroko | Excel | 0 | 01-09-2008 07:27 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode