Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Home Page

Bloglines

1906
CelebrateStadium
2006


OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal












Subscribe here
Add to 

My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com



  Wednesday, November 04, 2009 – Permalink –

Paste is Special

Versatile functions


If the data you brought into Excel comes through as text rather than numbers, Paste Special can fix it.

  1. Go to an empty cell.
  2. Copy it
  3. Select the "corrupted" data.
  4. Go to Edit>Paste Special and choose Add.
This works better than multiplying by one. Empty cells remain empty


What's So Special About "Paste Special"?

Excel Paste Special function

Pasting Using Paste Special




See all Topics

Labels:


<Doug Klippert@ 3:08 AM

Comments: Post a Comment