LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default Convert SMITH to Smith and JONES to Jones?

I have a big worksheet containing last names with all capitol letters. I
would like to convert the case of the names so that SMITH will become Smith
and JONES will become Jones. How can I accomplish this? I will appreciate
advice.
 
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
I need help fred smith scats Excel Worksheet Functions 1 November 14th 06 04:32 AM
Change Smith, John to John Smith Levi Excel Discussion (Misc queries) 4 May 3rd 06 03:53 PM
I am trying to change Smith, John to John Smith Levi Excel Discussion (Misc queries) 3 May 1st 06 11:55 PM
Change Smith, J to J Smith in a cell? Andrea Excel Discussion (Misc queries) 12 February 15th 06 03:05 PM
formula for doing Smith Jhon to Jhon Smith ? anandat Excel Discussion (Misc queries) 3 November 27th 04 03:42 PM


All times are GMT +1. The time now is 08:19 AM.

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"