Hi Bob.

Excel is not big on formatting. It may be better to paste into
Word first to get it nice and tidy and then then copy to Excel.
Not real pretty but at least you will achieve your goal.

HTH
Martin