[mso] Re: excel question
- From: "Green" <1z@xxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- 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
*************************************************************
Other related posts:
