Print

Print


Thanks for the tip.

Mary Jane

----- Original Message -----
From: "Cummings, Patrick" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Wednesday, January 19, 2005 1:55 PM
Subject: Re: mailing lists and Excel


Mary Jane

    You can also wrap it in the =PROPER() function, to change the text
to proper capitalization if it currently is not.

            i.e..  =PROPER(CONCATENATE(A1," ",B1))

    OR =UPPER() for all upper case

            i.e..  =UPPER(CONCATENATE(A1," ",B1))

    OR =LOWER() for all lower case

            i.e..  =LOWER(CONCATENATE(A1," ",B1))

 Patrick



-----Original Message-----
From: Vermont Municipal Government Discussion Network
[mailto:[log in to unmask]] On Behalf Of Mary Jane Grace
Sent: Tuesday, January 18, 2005 3:20 PM
To: [log in to unmask]
Subject: mailing lists and Excel


Here's something I learned when trying to use an Excel file with
people's names and addresses.

Example, I had the first name in one column and the last name in another
column.  I wanted the name all together in one column.  That is, instead
of

Column A           Column B
Mary Jane            Grace

I want it to be in a single column as

Mary Jane Grace

You can use a command called Concatenate to put the two together as one
name in another column.  The formula looks like this:

=CONCATENATE(A1," ",B1)

The A1 cell is where Mary Jane resides

the " " puts in the space

The B1 cells is where Grace resides.

New cell is Mary Jane Grace


Thought some might find this handy.

Mary Jane Grace
Property Valuation and Review Div.
Vermont Department of Taxes
802-828-5863
[log in to unmask]