Table formatting lost

  • Thread starter Thread starter him
  • Start date Start date
H

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?
 
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
 
Back
Top