Changing file in all upper case to upper and lower case

I could successfully execute your instructions through the =PROPER (B2) step,
but after I highlight and copy the results (Mr. And Mrs.) I don't understand
how to do the VALUE, Esc. I've gone to Help, and it says VALUE is for
numbers and gives an example that doesn't apply to me. Could you please
explain it in a little more detail. Thanks.
--
S Jan


"Sunantoro" wrote:

> Basically you need to insert a temporary column and place the function:
> =Proper( ) and copy it all the way down. highlight the results and click Copy
> - Value - Esc. Highlight again and copy to the original name cells. Same
> method for the addresses.
> SUNAN
>
> "Sagit" wrote:
>
> > I have a file of names and addresses that were entered in all upper case. Is
> > there a fast way to change this file into upper and lower case? Thanks for
> > any help you can give me.
> > --
> > S Jan

Eliminate this list dance is why it is so much easier using a macro.

You have a column perhaps starting in A1
You placed a formula dependent on column A into cell B1:
=PROPER(A1)

You would like to climate column A, but can't because column B
is dependent on Column A.

Select column B, then copy (ctrl+C)
With B still selected
Edit, Paste Special, Values, [Ok] -- not Escape

Values refers to text and characters, in this context.
You will see that the formulas have been converted to values
and can then remove column A.

Use of a macro is so much faster.


HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Sagit" <Sagit@discussions.microsoft.com> wrote in message news:4970BD38-900F-4C7A-9C3E-1850B14FF4B6@microsoft.com...
> I could successfully execute your instructions through the =PROPER (B2) step,
> but after I highlight and copy the results (Mr. And Mrs.) I don't understand
> how to do the VALUE, Esc. I've gone to Help, and it says VALUE is for
> numbers and gives an example that doesn't apply to me. Could you please
> explain it in a little more detail. Thanks.
> --
> S Jan
>
>
> "Sunantoro" wrote:
>
> > Basically you need to insert a temporary column and place the function:
> > =Proper( ) and copy it all the way down. highlight the results and click Copy
> > - Value - Esc. Highlight again and copy to the original name cells. Same
> > method for the addresses.
> > SUNAN
> >
> > "Sagit" wrote:
> >
> > > I have a file of names and addresses that were entered in all upper case. Is
> > > there a fast way to change this file into upper and lower case? Thanks for
> > > any help you can give me.
> > > --
> > > S Jan

OK, I gotcha now. The mistake I made was in doing a Paste, instead of a
Paste Special. You are right, this is tedious. But I have accomplished what
I needed. Now, I will learn how to do it with a macro. Thank you so very
much for your extra tutoring. You are great.
--
S Jan


"David McRitchie" wrote:

> Eliminate this list dance is why it is so much easier using a macro.
>
> You have a column perhaps starting in A1
> You placed a formula dependent on column A into cell B1:
> =PROPER(A1)
>
> You would like to climate column A, but can't because column B
> is dependent on Column A.
>
> Select column B, then copy (ctrl+C)
> With B still selected
> Edit, Paste Special, Values, [Ok] -- not Escape
>
> Values refers to text and characters, in this context.
> You will see that the formulas have been converted to values
> and can then remove column A.
>
> Use of a macro is so much faster.
>
>
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Sagit" <Sagit@discussions.microsoft.com> wrote in message news:4970BD38-900F-4C7A-9C3E-1850B14FF4B6@microsoft.com...
> > I could successfully execute your instructions through the =PROPER (B2) step,
> > but after I highlight and copy the results (Mr. And Mrs.) I don't understand
> > how to do the VALUE, Esc. I've gone to Help, and it says VALUE is for
> > numbers and gives an example that doesn't apply to me. Could you please
> > explain it in a little more detail. Thanks.
> > --
> > S Jan
> >
> >
> > "Sunantoro" wrote:
> >
> > > Basically you need to insert a temporary column and place the function:
> > > =Proper( ) and copy it all the way down. highlight the results and click Copy
> > > - Value - Esc. Highlight again and copy to the original name cells. Same
> > > method for the addresses.
> > > SUNAN
> > >
> > > "Sagit" wrote:
> > >
> > > > I have a file of names and addresses that were entered in all upper case. Is
> > > > there a fast way to change this file into upper and lower case? Thanks for
> > > > any help you can give me.
> > > > --
> > > > S Jan
>
>
>

My husband told me that before I can use a macro, I need to have a VB
compiler. He said they are expensive. Not that I don't have confidence in
my husband's knowledge, but could you please confirm that and where is the
best place to buy one?
--
S Jan


"David McRitchie" wrote:

> Eliminate this list dance is why it is so much easier using a macro.
>
> You have a column perhaps starting in A1
> You placed a formula dependent on column A into cell B1:
> =PROPER(A1)
>
> You would like to climate column A, but can't because column B
> is dependent on Column A.
>
> Select column B, then copy (ctrl+C)
> With B still selected
> Edit, Paste Special, Values, [Ok] -- not Escape
>
> Values refers to text and characters, in this context.
> You will see that the formulas have been converted to values
> and can then remove column A.
>
> Use of a macro is so much faster.
>
>
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Sagit" <Sagit@discussions.microsoft.com> wrote in message news:4970BD38-900F-4C7A-9C3E-1850B14FF4B6@microsoft.com...
> > I could successfully execute your instructions through the =PROPER (B2) step,
> > but after I highlight and copy the results (Mr. And Mrs.) I don't understand
> > how to do the VALUE, Esc. I've gone to Help, and it says VALUE is for
> > numbers and gives an example that doesn't apply to me. Could you please
> > explain it in a little more detail. Thanks.
> > --
> > S Jan
> >
> >
> > "Sunantoro" wrote:
> >
> > > Basically you need to insert a temporary column and place the function:
> > > =Proper( ) and copy it all the way down. highlight the results and click Copy
> > > - Value - Esc. Highlight again and copy to the original name cells. Same
> > > method for the addresses.
> > > SUNAN
> > >
> > > "Sagit" wrote:
> > >
> > > > I have a file of names and addresses that were entered in all upper case. Is
> > > > there a fast way to change this file into upper and lower case? Thanks for
> > > > any help you can give me.
> > > > --
> > > > S Jan
>
>
>

You don't need to purchase VB. Excel comes with VBA which is
all you need for macros. Before you can use macros you must
set security level within Excel to Medium.
tools, macros, security, medium, [OK]

To install macros you find in newsgroups or websites, see
http://www.mvps.org/dmcritchie/excel/getstarted.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Sagit" <Sagit@discussions.microsoft.com> wrote in message news:F8480C68-7954-47E4-865D-FDCD49927930@microsoft.com...
> My husband told me that before I can use a macro, I need to have a VB
> compiler. He said they are expensive. Not that I don't have confidence in
> my husband's knowledge, but could you please confirm that and where is the
> best place to buy one?
> --
> S Jan
>
>
> "David McRitchie" wrote:
>
> > Eliminate this list dance is why it is so much easier using a macro.
> >
> > You have a column perhaps starting in A1
> > You placed a formula dependent on column A into cell B1:
> > =PROPER(A1)
> >
> > You would like to climate column A, but can't because column B
> > is dependent on Column A.
> >
> > Select column B, then copy (ctrl+C)
> > With B still selected
> > Edit, Paste Special, Values, [Ok] -- not Escape
> >
> > Values refers to text and characters, in this context.
> > You will see that the formulas have been converted to values
> > and can then remove column A.
> >
> > Use of a macro is so much faster.
> >
> >
> > HTH,
> > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> >
> > "Sagit" <Sagit@discussions.microsoft.com> wrote in message news:4970BD38-900F-4C7A-9C3E-1850B14FF4B6@microsoft.com...
> > > I could successfully execute your instructions through the =PROPER (B2) step,
> > > but after I highlight and copy the results (Mr. And Mrs.) I don't understand
> > > how to do the VALUE, Esc. I've gone to Help, and it says VALUE is for
> > > numbers and gives an example that doesn't apply to me. Could you please
> > > explain it in a little more detail. Thanks.
> > > --
> > > S Jan
> > >
> > >
> > > "Sunantoro" wrote:
> > >
> > > > Basically you need to insert a temporary column and place the function:
> > > > =Proper( ) and copy it all the way down. highlight the results and click Copy
> > > > - Value - Esc. Highlight again and copy to the original name cells. Same
> > > > method for the addresses.
> > > > SUNAN
> > > >
> > > > "Sagit" wrote:
> > > >
> > > > > I have a file of names and addresses that were entered in all upper case. Is
> > > > > there a fast way to change this file into upper and lower case? Thanks for
> > > > > any help you can give me.
> > > > > --
> > > > > S Jan
> >
> >
> >

My husband and I both learned something, thanks to you. I will check it out
and thanks once again. I love this newsgroup - everyone is not only very
knowledgeable, but so very nice and helpful, you especially.
--
S Jan


"David McRitchie" wrote:

> You don't need to purchase VB. Excel comes with VBA which is
> all you need for macros. Before you can use macros you must
> set security level within Excel to Medium.
> tools, macros, security, medium, [OK]
>
> To install macros you find in newsgroups or websites, see
> http://www.mvps.org/dmcritchie/excel/getstarted.htm
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Sagit" <Sagit@discussions.microsoft.com> wrote in message news:F8480C68-7954-47E4-865D-FDCD49927930@microsoft.com...
> > My husband told me that before I can use a macro, I need to have a VB
> > compiler. He said they are expensive. Not that I don't have confidence in
> > my husband's knowledge, but could you please confirm that and where is the
> > best place to buy one?
> > --
> > S Jan
> >
> >
> > "David McRitchie" wrote:
> >
> > > Eliminate this list dance is why it is so much easier using a macro.
> > >
> > > You have a column perhaps starting in A1
> > > You placed a formula dependent on column A into cell B1:
> > > =PROPER(A1)
> > >
> > > You would like to climate column A, but can't because column B
> > > is dependent on Column A.
> > >
> > > Select column B, then copy (ctrl+C)
> > > With B still selected
> > > Edit, Paste Special, Values, [Ok] -- not Escape
> > >
> > > Values refers to text and characters, in this context.
> > > You will see that the formulas have been converted to values
> > > and can then remove column A.
> > >
> > > Use of a macro is so much faster.
> > >
> > >
> > > HTH,
> > > David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> > > My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> > > Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
> > >
> > > "Sagit" <Sagit@discussions.microsoft.com> wrote in message news:4970BD38-900F-4C7A-9C3E-1850B14FF4B6@microsoft.com...
> > > > I could successfully execute your instructions through the =PROPER (B2) step,
> > > > but after I highlight and copy the results (Mr. And Mrs.) I don't understand
> > > > how to do the VALUE, Esc. I've gone to Help, and it says VALUE is for
> > > > numbers and gives an example that doesn't apply to me. Could you please
> > > > explain it in a little more detail. Thanks.
> > > > --
> > > > S Jan
> > > >
> > > >
> > > > "Sunantoro" wrote:
> > > >
> > > > > Basically you need to insert a temporary column and place the function:
> > > > > =Proper( ) and copy it all the way down. highlight the results and click Copy
> > > > > - Value - Esc. Highlight again and copy to the original name cells. Same
> > > > > method for the addresses.
> > > > > SUNAN
> > > > >
> > > > > "Sagit" wrote:
> > > > >
> > > > > > I have a file of names and addresses that were entered in all upper case. Is
> > > > > > there a fast way to change this file into upper and lower case? Thanks for
> > > > > > any help you can give me.
> > > > > > --
> > > > > > S Jan
> > >
> > >
> > >
>
>
>
>