I was sent an e-mail with some data from an excel sheet embedded in it. I want to extract that data to another Excel spreadsheet. When I try to copy and paste it, it insists on pasting it as an object which does not allow me to work with the data.
- Copy the table in the outlook email.
- open a new excel sheet and select Paste Special
- Paste as text