LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default creating a proper text formula

I've created my own data source in Excel. The first 2 cells are mostly all
caps. I want to have them proper. I've formatted all the cells to general.
I've tried all sorts of ways to enter a formula but nothing seems to work. I
keep getting a "name?" error. Is there an easy way to change the text w/o
retyping it. I'm beginning to think that might be easier. Thanks!
 
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
Cannot change text to proper case using formula LaDena Excel Worksheet Functions 2 December 18th 07 05:33 PM
Formula: =PROPER(text), won't display result. hornbss Excel Discussion (Misc queries) 3 January 29th 07 04:02 AM
Help Creating A Formula To Cut and Paste Text Mary Excel Worksheet Functions 7 August 7th 06 07:04 AM
How do I change text to proper when text is already in upper? K New Users to Excel 2 February 8th 06 10:32 AM
How can I change text to proper text in multiple cells. bethye99 Excel Discussion (Misc queries) 1 January 10th 06 06:17 PM


All times are GMT +1. The time now is 02:41 PM.

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

About Us

"It's about Microsoft Excel"