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
|