Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default how to change existing column to capital letters

current column is mixed upper and lower case names. I want the entire column
to be capital letters.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default how to change existing column to capital letters

Hi Fred

Assuming data is in column A, then in an empty column enter
=UPPER(A1)
Copy down new column for the extent of data in column A.
Copy new column and Paste SpecialValues back over column A.
Delete new column.

--
Regards

Roger Govier


"fredg" wrote in message
...
current column is mixed upper and lower case names. I want the entire
column
to be capital letters.



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default how to change existing column to capital letters

Roger: Thank you for your assistance. I tried your suggestion, but all it
did was copy the 1st name down the entire column. Did I do something wrong?
I tried your suggestion numerous times to eliminate any errors on my part,
but i kept getting the same results. Pls. reply.

thanks in advance!!
fredg

"Roger Govier" wrote:

Hi Fred

Assuming data is in column A, then in an empty column enter
=UPPER(A1)
Copy down new column for the extent of data in column A.
Copy new column and Paste SpecialValues back over column A.
Delete new column.

--
Regards

Roger Govier


"fredg" wrote in message
...
current column is mixed upper and lower case names. I want the entire
column
to be capital letters.




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default how to change existing column to capital letters

Hi

It sounds as though ToolsOptionsCalculation is set to Manual.
Select Automatic instead and it should work fine.

--
Regards

Roger Govier


"fredg" wrote in message
...
Roger: Thank you for your assistance. I tried your suggestion, but
all it
did was copy the 1st name down the entire column. Did I do something
wrong?
I tried your suggestion numerous times to eliminate any errors on my
part,
but i kept getting the same results. Pls. reply.

thanks in advance!!
fredg

"Roger Govier" wrote:

Hi Fred

Assuming data is in column A, then in an empty column enter
=UPPER(A1)
Copy down new column for the extent of data in column A.
Copy new column and Paste SpecialValues back over column A.
Delete new column.

--
Regards

Roger Govier


"fredg" wrote in message
...
current column is mixed upper and lower case names. I want the
entire
column
to be capital letters.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
nedd to change column headings from numbers back to letters chucklinda525 New Users to Excel 2 December 29th 06 06:16 PM
macro unouwanme Excel Discussion (Misc queries) 9 August 31st 06 09:38 PM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 04:56 AM
change column name from letters to numbers? Jerry Excel Discussion (Misc queries) 2 June 28th 05 07:08 PM
How do I change column labels from numbers to letters in Excel? AllisonCincy Excel Discussion (Misc queries) 2 December 9th 04 01:55 AM


All times are GMT +1. The time now is 08:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"