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

  • From: "Carl" <ctm007@xxxxxxxxxxxxxx>
  • To: <pcductape@xxxxxxxxxxxxx>
  • Date: Tue, 23 Dec 2003 04:50:03 -0600

Thanks Scott.
Carl

----- Original Message ----- 
From: "Scott McNay" <Wizard@xxxxxxxx>
To: "Carl" <pcductape@xxxxxxxxxxxxx>
Sent: Monday, December 22, 2003 10:59 PM
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
one
> C> person's name on line 1a and his address on line/row 2a and his zipcode
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.

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: