Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keep Cell Data Blank when Copying It | Excel Discussion (Misc queries) | |||
how can i fill data in blank cells after copying a pivot report? | Excel Discussion (Misc queries) | |||
Need help copying cells into rows with spaces between | Excel Discussion (Misc queries) | |||
Sorting and copying data to another worksheet in a workbook. | Excel Discussion (Misc queries) | |||
Automatic copying data excluding blank cells | Excel Worksheet Functions |