# need excel help.

**URL:** <https://forums.speedlife.net/t/need-excel-help/65348>\
**Category:** NYSpeed Off Topic\
**Created:** [March 30, 2009, 4:03pm UTC](https://forums.speedlife.net/t/need-excel-help/65348 "2009-03-30T16:03:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![JustinH](https://avatars.discourse-cdn.com/v4/letter/j/9fc29f/32.png) [@JustinH](https://forums.speedlife.net/u/JustinH)\
**Post date:** [March 30, 2009, 4:03pm UTC](https://forums.speedlife.net/t/need-excel-help/65348/1 "2009-03-30T16:03:23Z")

</div>

I’m doing some tracking of errors at work…

We get a report emailed every half hour with batch numbers on it, and other information.

The report comes in rainbow colors I swear to God… Sometimes its red with green background, other times it is yellow.

The email that I get has the batches laid out in grid like a spreadsheet.

I need to copy/paste into a spreadsheet that I have made for error tracking.

How can I paste without all the weird formatting? I’ve messed with the cell properties in excel to make them just standard text, but I can’t figure it out.

A paste with formatting always goes through, or sometimes I get white text which is AWESOME…

---

<div class="post-metadata">

**Author:** ![Fry](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/fry/32/7284_2.png) [@Fry](https://forums.speedlife.net/u/Fry)\
**Post date:** [March 30, 2009, 4:32pm UTC](https://forums.speedlife.net/t/need-excel-help/65348/2 "2009-03-30T16:32:11Z")

</div>

Paste Special --\> Paste Values

?

---

<div class="post-metadata">

**Author:** ![duck](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/duck/32/7183_2.png) [@duck](https://forums.speedlife.net/u/duck)\
**Post date:** [April 2, 2009, 7:00am UTC](https://forums.speedlife.net/t/need-excel-help/65348/3 "2009-04-02T07:00:01Z")

</div>

i added the Paste Special Values button to my excel toolbar. I swear by it.

I also have a program installed called PureText.  
If I copy (Ctrl+C) then press Windows Key+V, it will paste into anything as values.
