Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Change from mixed caps and upper lower to all upper lower case

I have ever changing data base that imports as both mixed upper/lower and all
caps. I want to change all text to initial caps. Any formula in EXCEL to do
this?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default Change from mixed caps and upper lower to all upper lower case

=proper

--
Don Guillett
SalesAid Software

"Fish''s Mermaid" wrote in message
...
I have ever changing data base that imports as both mixed upper/lower and
all
caps. I want to change all text to initial caps. Any formula in EXCEL to
do
this?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 751
Default Change from mixed caps and upper lower to all upper lower case

In a new column:

=PROPER(A1)

Later, if you want, you can copy the formula column and Edit|Paste
Special...|Values, you can paste the values over the original column.

HTH
Kostis Vezerides

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Change from mixed caps and upper lower to all upper lower case

Thanks that works.

"Don Guillett" wrote:

=proper

--
Don Guillett
SalesAid Software

"Fish''s Mermaid" wrote in message
...
I have ever changing data base that imports as both mixed upper/lower and
all
caps. I want to change all text to initial caps. Any formula in EXCEL to
do
this?




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
Upper Case Vs: Lower case Bill Carpenter Excel Discussion (Misc queries) 5 May 30th 07 06:05 AM
Excel: How do I change all upper case ss to proper case? Moosieb Excel Worksheet Functions 3 January 13th 06 01:45 AM
CHANGE LOWER TO UPPER CASE IN EXCEL FOR WHOLE SPRDSHT Impossible One Excel Worksheet Functions 1 May 13th 05 09:33 PM
How do I convert all upper case excel sheet into upper and lower . DebDay Excel Discussion (Misc queries) 1 March 9th 05 09:31 PM
Change source text in Excel from all caps to upper and lower case. JoanS Excel Discussion (Misc queries) 2 December 16th 04 03:11 AM


All times are GMT +1. The time now is 02:07 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"