Table formatting lost

[him]

I receive emails that started off in Excel as a short table. The
sender then cuts and pastes into Outlook. When the message arrives it
has lost all formatting for the table. Is there any solution apart
from sennding as an Excel attachment?

 

[Gary''s Student]

Do the copy as a Picture and then paste in Outlook.

 

[Niek Otten]

Let's say the 1000 is in A1 and the 500 is in A6. Put the number of lines,
including the last one, in B1; in this example 5.
In A2:A5, use this formula:

=A1-($A$1-OFFSET($A$1,$B$1,))/$B$1

 

[Niek Otten]

Sorry, replied to wrong message