Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default copying/sorting data with blank spaces in between?

I have a membership list I need to update for a club. I have used Excel very
little.
I have been trying some different things to see if this will work before I
get the data file (which I will back up before hand)
In 3 columns to the right it has year dates in them. I need to change them.
depending on the person, the first column would all be the same changed from
2007 to 2008. The problem is, there are spaces between some of those
particular columns. (see below) when I try to highlight them individually and
past, say 2008, it will not allow me. Is their a way to do this? It says I
can't do this in multiple selections.
2007

2007
2007

2007
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 181
Default copying/sorting data with blank spaces in between?

Use the "replace" facility to be found in editing.
2007
Highlight your range
Find and Select in the Editing area
Replace
2007
2008
Replace all
OK

Russell Dawson
Excel Student

Please hit "Yes" if this post was helpful.


"brucefl" wrote:

I have a membership list I need to update for a club. I have used Excel very
little.
I have been trying some different things to see if this will work before I
get the data file (which I will back up before hand)
In 3 columns to the right it has year dates in them. I need to change them.
depending on the person, the first column would all be the same changed from
2007 to 2008. The problem is, there are spaces between some of those
particular columns. (see below) when I try to highlight them individually and
past, say 2008, it will not allow me. Is their a way to do this? It says I
can't do this in multiple selections.
2007

2007
2007

2007

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep Cell Data Blank when Copying It king60611 Excel Discussion (Misc queries) 5 January 9th 10 12:02 AM
how can i fill data in blank cells after copying a pivot report? Antz Excel Discussion (Misc queries) 1 August 7th 08 02:11 PM
Need help copying cells into rows with spaces between Doug Titus Excel Discussion (Misc queries) 0 July 25th 08 06:00 PM
Sorting and copying data to another worksheet in a workbook. Geo Excel Discussion (Misc queries) 3 June 5th 06 09:58 PM
Automatic copying data excluding blank cells Wesley Excel Worksheet Functions 6 November 30th 04 02:17 AM


All times are GMT +1. The time now is 11:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"