LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Dave
 
Posts: n/a
Default Changing text from all caps to first letter cap

I have a file with alot of columns of data. In a couple of the columns, the
words are typed with all caps. I would like the words to have only the first
letter of each word capitalized. I can not do an edit/replace because there
are many different words. Is there a formatting or edit/replace trick that I
can use to accomplish this? Any information is appreciated.

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
Why is my text changing to pound signs? SleepyDawn Excel Discussion (Misc queries) 2 February 9th 05 10:52 PM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Change source text in Excel from all caps to upper and lower case. JoanS Excel Discussion (Misc queries) 2 December 16th 04 02:11 AM
Making text all CAPS in excel Jon Excel Worksheet Functions 4 December 13th 04 09:06 PM
Is there a way I can enter a letter to proceed text a column of ce Gordon Excel Discussion (Misc queries) 3 December 13th 04 07:13 PM


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