Home Archives for Paste Special
July 25, 2008 Leave a Comment

Use the proper text function to change the case

Here are the steps to follow in this lesson:

  1. Use the =PROPER() function to convert your text string.
  2. Look out for names like “Mckinley” – You will need to edit these cells manually by:
  3. Changing the cells from Formulas to Values using Copy, Paste Special, Values. Then edit each cell.
  4. Before deleting a column of data, be sure to change the cells from Formulas to Values.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, Text Functions Tagged: , , ,
July 22, 2008 Leave a Comment

Use Paste Special, Add to combine data from 2 columns

Here are the steps to follow for this lesson:

  1. Copy the data in the new column.
  2. Select the top cell in the original column and click Paste Special, Add
  3. To preserve any special formatting in the original column take this extra step:
  4. Click Paste Special, Values, Add

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Training, Tips and Time Savers Tagged: ,
July 21, 2008 1 Comment

How to identify and convert text values to numbers

Here are the steps to follow in this lesson:

  1. Very that all values are actually numbers e.g. use the =COUNT() and =ISTEXT() functions.
  2. To convert a series a text values to numbers, first select a blank cell and copy it to the clipboard.
  3. Highlight your text values and choose Edit, Paste Special. In the Paste Special Dialog Box choose ADD.
  4. All text values are now converted into numbers that can be summed, etc.

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.

Link to this post!
Filed Under: Excel Functions, Excel Training, Tips and Time Savers Tagged: , ,
July 7, 2008 3 Comments

Transpose your data

You can turn your Excel data on its side – literally! When you use the Transpose option from the Paste Special dialog box you can turn data from a Horizontal Orientation to Vertical one – or vice versa. It’s easy to do this as you will see in this video.

Here are the steps to follow for today’s tip:

1) Select the data area and copy it to the clipboard

2) Right-click a blank cell in an open area of your worksheet

3) Select “paste special” and check the “transpose” box and then click OK

Find the video lesson that you want – Index to all Excel Topics

Link to this post!
Filed Under: Excel Training, Tips and Time Savers Tagged: , , ,
« Previous Page