[pcductape] Re: How to convert 1st word to last in a spreadsheet column

  • From: "Carl" <ctm007@xxxxxxxxxxxxxx>
  • To: <pcductape@xxxxxxxxxxxxx>
  • Date: Sun, 28 Dec 2003 06:35:24 -0600

Hi Scott,

You are really smart with spreadsheets.   Do you teach the stuff?   :-)

Thanks,

Carl

----- Original Message ----- 
From: "Scott McNay" <Wizard@xxxxxxxx>
To: "Carl" <pcductape@xxxxxxxxxxxxx>

> Hi Carl,
> Here's what I have:
>
> Cell #:    Contents:
> A1         Last First A & Second B
> D1         =TRIM(LEFT(A1,FIND(" ",A1)))
> E1         =TRIM(MID(A1,FIND(" ",A1)+1,FIND("&",A1,FIND(" ",A1))-FIND("
",A1)-1))
> F1         =TRIM(MID(A1,FIND("&",A1,FIND("
",A1))+1,LEN(A1)-FIND("&",A1,FIND(" ",A1))))
>
> When you copy and paste formulas, the cell references adjust to match,
> so you only need to fill in the first row, then copy those 3 cells,
> mark the remainder of the cells, and paste; the other cells should get
> filled with the correct results.  If the name is not in cell A, use
> the appropriate letter.
>
> This results in:
>   Last
>   First A
>   Second B
>
> --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 view the message archives simply go to: 
http://www.freelists.org/archives/pcductape/

Other related posts: