[pcductape] Re: Fw: [PC-Ductape] Spreadsheet question

  • From: Scott McNay <Wizard@xxxxxxxx>
  • To: Carl <pcductape@xxxxxxxxxxxxx>
  • Date: Tue, 23 Dec 2003 07:44:07 -0600

Hi Carl,

Oops, I meant to say...

   Mark cells B1 through C3, and copy. Then, mark cells B4 through
   the last row of C, then paste.

Doing it the way that I said originally will keep the sort from doing
anything useful.

--Scott.


Tuesday, December 23, 2003, 4:50:03 AM, you wrote:

C> Thanks Scott.
C> Carl

C> ----- Original Message ----- 
C> From: "Scott McNay" <Wizard@xxxxxxxx>
C> To: "Carl" <pcductape@xxxxxxxxxxxxx>
C> Sent: Monday, December 22, 2003 10:59 PM
C> Subject: [pcductape] Re: Fw: [PC-Ductape] Spreadsheet question


>>
>> Hi Carl,
>>
>> Monday, December 22, 2003, 10:55:33 AM, you wrote:
>>
>> C> I was in too big a hurry and failed to explain my problem properly.
>> C> Somehow my spreadsheet of names and addresses became corrupt and I have
C> one
>> C> person's name on line 1a and his address on line/row 2a and his zipcode
C> on
>> C> line/row 3a. I am trying to convert "row 2a" into column 1b
>> C> and "row 3a" into column 1c.
>>
>> If this is a one-shot thing, here's what you can do:
>>
>> In cell B1, type the formula
>>
>>    =A2
>>
>> In cell C1, type the formula
>>
>>    =A3
>>
>> Mark cells B1 and C1, and copy.  Then, mark cells B2 through the last
>> row of C, then paste.
>>
>> Then, mark cells A1 through the last cell of C, copy, then right-click
>> on the marked area and select Paste Special.  When prompted, pick
>> "Values", hen click Ok.  This replaces the formulas with the actual
>> text.
>>
>> Then, you can go through and sort the list by column B, then you can
>> mark the 200 short lines and then delete them.
>>
>>
>> --Scott.
>>
>>
>> To unsubscribe from this list send an email to
>> pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject field
>> OR by logging into the Web interface.

C> To unsubscribe from this list send an email to
C> pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject field
C> OR by logging into the Web interface. 


--Scott.


To unsubscribe from this list send an email to
pcductape-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject field
OR by logging into the Web interface. 

Other related posts: