If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|