Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Discussion (Misc queries) > How do I change the case in Excel Spreadsheet
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 do I change the case in Excel Spreadsheet
I have ready the posts regarding this subject. I'm an idiot evidentally.
Actually, i've never done this before.

I've tried entering the =PROPER(text) formula, nothing happens. I've tried
copying to VBA (which I don't even know what any of this means) nothing
happens. What is the quickest way to find a step by step solution for
DUMMIES?????
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 427
Default How do I change the case in Excel Spreadsheet
The PROPER() function changes the first letter to upper case, and
leaves the rest as lower case. Try using UPPER(text) and see if that
works. If it doesn't, please post back with examples so we can
troubleshoot with you.

Reply With QuoteReply With Quote
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 427
Default How do I change the case in Excel Spreadsheet
Minor clarification:
The PROPER() function changes the first letter to upper case
should read as
The PROPER() function changes the first letter of each word in the text
string to upper case

Reply With QuoteReply With Quote
  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
  
Posts: 22,906
Default How do I change the case in Excel Spreadsheet
Assuming you have text in A1 like john smith

In B1 enter =PROPER(A1)

Returns John Smith


Gord Dibben MS Excel MVP


On Mon, 30 Oct 2006 13:16:02 -0800, hornbss
wrote:

I have ready the posts regarding this subject. I'm an idiot evidentally.
Actually, i've never done this before.

I've tried entering the =PROPER(text) formula, nothing happens. I've tried
copying to VBA (which I don't even know what any of this means) nothing
happens. What is the quickest way to find a step by step solution for
DUMMIES?????

Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

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
HOW CAN I CONVERT A NUM IN WORDS (EXCEL) Harry Excel Discussion (Misc queries) 3 July 11th 06 02:09 PM
how to use spellnumber formula Aarif Excel Worksheet Functions 3 February 27th 06 04:36 PM
spell number JAWAD CHOHAN Excel Worksheet Functions 1 December 12th 05 05:58 PM
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM


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

 

Contact Us ExcelBanter forum home Privacy Statement