LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 103
Default Extract Uppercase Letters

Accidentally posted to Excel General Questions earlier.
Using VBA how would I have the username like Joseph T. Smith be JTS in a
cell? The name could be any length, and if there is not a middle initial such
as Pete Loveless it would be PL.
Thanks for any and all advice and examples.


 
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
Counting only uppercase letters with wildcard in column/row TJA New Users to Excel 6 September 20th 07 11:52 PM
In Excel, can you change uppercase letters to lowercase mdh6245 New Users to Excel 2 September 4th 07 10:06 PM
excel: count uppercase letters in a cell harry bachrach Excel Worksheet Functions 13 July 13th 07 03:58 PM
Why do all my cells automatically turn into uppercase letters? Tomcat Excel Discussion (Misc queries) 2 October 3rd 05 12:09 AM
CHANGE WHOLE EXCEL worksheet TO UPPERCASE LETTERS? mineralgirl Excel Discussion (Misc queries) 4 September 3rd 05 01:29 AM


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