[mso] Re: excel question
- From: "Mike Henneman" <mike3375@xxxxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Wed, 22 Sep 2004 10:39:03 -0400
Thank you very much..!!! and YES I do need all uppercase because i'm crazy
like that:-)
>From: "Green" <1z@xxxxxxxxxxxxxx>
>Reply-To: mso@xxxxxxxxxxxxx
>To: <mso@xxxxxxxxxxxxx>
>Subject: [mso] Re: excel question
>Date: Wed, 22 Sep 2004 15:27:27 +0200
>
>Hi Mike,
>
>You need to do a bit of copy and pasting or write a very short VBA
>routine.
>
>In a seperate column type "=Upper(Contact Cell)" where Contact Cell is
>the address of the first data cell for Contact. This will put the
>upper case of the referenced cell into the new cell. Then you can use
>fill down to copy the formula to the bottom of the list and over to
>the right.
>
>This should give you a second set of data over to the righ of the
>first but all in upper case.
>
>Now select all of the upper case data and Copy. Now Paste special /
>values only back over the original data. Finally you can delete the
>created upper case data 'cause you don't need it any more.
>
>Do you really need *all* of it in upper case though?
>
>HTH
>Regards
>Lisa
>
> > Hi everyone
> >
> > I have a list of addresses in excel with each part of the
> > address seperated
> > in columns like below:
> >
> > contact address1 address2 city state zip
> >
> > My problem is I have ALOT of addresses and some are upper
> > case and some are
> > lower case and I would like them all to be upper case. I
> > realize there is a
> > UPPER formula put I can't figure out how to use it or if I
> > even can. any
> > help?
> >
> > Thanks
> >
> > Mike
>
>
>*************************************************************
>You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
>MicrosoftOffice@xxxxxxxxxxxxxxxx
>
>To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
>To Unsubscribe from this group, send an email to
>mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes)
>in the subject line.
>
>Or, visit the group's homepage and use the dropdown menu. This will also
>allow you to change your email settings to digest or vacation (no mail).
>//www.freelists.org/webpage/mso
>
>To be able to use the files section for sharing files with the group, send
>a request to mso-moderators@xxxxxxxxxxxxx and you will be sent an
>invitation with instructions. Once you are a member of the files group,
>you can go here to upload/download files:
>http://www.smartgroups.com/vault/msofiles
>*************************************************************
_________________________________________________________________
Don?t just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, send an email to
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in
the subject line.
Or, visit the group's homepage and use the dropdown menu. This will also allow
you to change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to use the files section for sharing files with the group, send a
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with
instructions. Once you are a member of the files group, you can go here to
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************
Other related posts:
