PC Review

Thread Tools Rate Thread

copying/sorting data with blank spaces in between?

Posts: n/a
      6th Mar 2010
I have a membership list I need to update for a club. I have used Excel very
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.


Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
spaces not recognized as spaces windsurferLA Microsoft Excel Worksheet Functions 9 27th Jul 2006 11:49 AM
How can I replace single spaces with double spaces in a document . =?Utf-8?B?QW1lcmljbkpld2w=?= Microsoft Word Document Management 5 27th Feb 2005 05:22 AM
I cannot type two sequential letters or spaces or back spaces? =?Utf-8?B?VExUaG9tYXM=?= Microsoft Word Document Management 1 30th Nov 2004 09:02 AM
Spaces not being recognized be excel as spaces!! Help! Kevin Microsoft Excel Worksheet Functions 4 11th May 2004 12:05 AM
Help copying a range with spaces to a range without spaces Andy Microsoft Excel Programming 1 23rd Sep 2003 04:26 PM




All times are GMT +1. The time now is 08:05 AM.