software

I'm trying to convert data (a list of names) in a single column to all caps.
I've tried copying and pasting the text from Word, but the data doesn't
change.

I can't get the instructions in Excel help to fix it either....

ARG!!!!

In a column next to your data, enter the formula

=UPPER(A1)

where A1 is the first cell of your data, and then copy down as
far as you need to go. Then copy this result column and paste
special values over your original data.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Carriequot; gt; wrote in message
news
gt; I'm trying to convert data (a list of names) in a single column
gt; to all caps.
gt; I've tried copying and pasting the text from Word, but the data
gt; doesn't
gt; change.
gt;
gt; I can't get the instructions in Excel help to fix it either....
gt;
gt; ARG!!!!
Assume first name is in A1
In B1 (if B is in use, then insert a new B column) enter =UPPER(A1)
Copy formula down to last name (say row 100)
Select B1:B100, click Copy tool; use Edit | Paste Special and check the
Values box
Now the data is not a formula
So now you can delete column A
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;Carriequot; gt; wrote in message
news
gt; I'm trying to convert data (a list of names) in a single column to all
gt; caps.
gt; I've tried copying and pasting the text from Word, but the data doesn't
gt; change.
gt;
gt; I can't get the instructions in Excel help to fix it either....
gt;
gt; ARG!!!!
In a helper column put this and copy down........then copy gt; PasteSpecial gt;
Values to delete the formulas.......

=UPPER(A1)

Vaya con Dios,
Chuck, CABGx3
quot;Carriequot; wrote:

gt; I'm trying to convert data (a list of names) in a single column to all caps.
gt; I've tried copying and pasting the text from Word, but the data doesn't
gt; change.
gt;
gt; I can't get the instructions in Excel help to fix it either....
gt;
gt; ARG!!!!

Say you names are in column A. In an un-used column enter =UPPER(A1) and
copy down. Then copy the new column and paste/special as value back into A
--
Gary's Studentquot;Carriequot; wrote:

gt; I'm trying to convert data (a list of names) in a single column to all caps.
gt; I've tried copying and pasting the text from Word, but the data doesn't
gt; change.
gt;
gt; I can't get the instructions in Excel help to fix it either....
gt;
gt; ARG!!!!

This is also a standard feature of ASAP Utilities, available free at
www.asap-utilities.com

Vaya con Dios,
Chuck, CABGx3
quot;Carriequot; wrote:

gt; I'm trying to convert data (a list of names) in a single column to all caps.
gt; I've tried copying and pasting the text from Word, but the data doesn't
gt; change.
gt;
gt; I can't get the instructions in Excel help to fix it either....
gt;
gt; ARG!!!!

I must be a complete idiot, because I still couldn't get it to work.

Bummer.

quot;Chip Pearsonquot; wrote:

gt; In a column next to your data, enter the formula
gt;
gt; =UPPER(A1)
gt;
gt; where A1 is the first cell of your data, and then copy down as
gt; far as you need to go. Then copy this result column and paste
gt; special values over your original data.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt;
gt;
gt; quot;Carriequot; gt; wrote in message
gt; news
gt; gt; I'm trying to convert data (a list of names) in a single column
gt; gt; to all caps.
gt; gt; I've tried copying and pasting the text from Word, but the data
gt; gt; doesn't
gt; gt; change.
gt; gt;
gt; gt; I can't get the instructions in Excel help to fix it either....
gt; gt;
gt; gt; ARG!!!!
gt;
gt;
gt;

Where is your data?

In Chip's sample formula, he expected it to start in A1.

If your data is in column G, then you can insert a new column H and put:
=upper(g1)

and drag that formula down the column.Carrie wrote:
gt;
gt; I must be a complete idiot, because I still couldn't get it to work.
gt;
gt; Bummer.
gt;
gt; quot;Chip Pearsonquot; wrote:
gt;
gt; gt; In a column next to your data, enter the formula
gt; gt;
gt; gt; =UPPER(A1)
gt; gt;
gt; gt; where A1 is the first cell of your data, and then copy down as
gt; gt; far as you need to go. Then copy this result column and paste
gt; gt; special values over your original data.
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Cordially,
gt; gt; Chip Pearson
gt; gt; Microsoft MVP - Excel
gt; gt; Pearson Software Consulting, LLC
gt; gt; www.cpearson.com
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Carriequot; gt; wrote in message
gt; gt; news
gt; gt; gt; I'm trying to convert data (a list of names) in a single column
gt; gt; gt; to all caps.
gt; gt; gt; I've tried copying and pasting the text from Word, but the data
gt; gt; gt; doesn't
gt; gt; gt; change.
gt; gt; gt;
gt; gt; gt; I can't get the instructions in Excel help to fix it either....
gt; gt; gt;
gt; gt; gt; ARG!!!!
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

When I do this, my names are deleted/gone.

Anyone want to do this for me?

quot;Gary''s Studentquot; wrote:

gt; Say you names are in column A. In an un-used column enter =UPPER(A1) and
gt; copy down. Then copy the new column and paste/special as value back into A
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Carriequot; wrote:
gt;
gt; gt; I'm trying to convert data (a list of names) in a single column to all caps.
gt; gt; I've tried copying and pasting the text from Word, but the data doesn't
gt; gt; change.
gt; gt;
gt; gt; I can't get the instructions in Excel help to fix it either....
gt; gt;
gt; gt; ARG!!!!

I'm on a government computer...I can't download anything to this computer.
Sorry.

quot;CLRquot; wrote:

gt; This is also a standard feature of ASAP Utilities, available free at
gt; www.asap-utilities.com
gt;
gt; Vaya con Dios,
gt; Chuck, CABGx3
gt;
gt;
gt;
gt; quot;Carriequot; wrote:
gt;
gt; gt; I'm trying to convert data (a list of names) in a single column to all caps.
gt; gt; I've tried copying and pasting the text from Word, but the data doesn't
gt; gt; change.
gt; gt;
gt; gt; I can't get the instructions in Excel help to fix it either....
gt; gt;
gt; gt; ARG!!!!