Tim

Footprints in the snow of a warped mind

Excel change case -sentance, proper, lower and upper

Blog Home About Me Photo Album The Site Doctor Blog Feed by Email Portfolio

Where to find me

Flickr Icon  Twitter Icon  Linked In Icon  FaceBook Icon  Windows Live Alerts Butterfly  RSS 2.0 

Tag Cloud

AJAX (4) ASP (6) ASP.Net (50) Error Reporting (4) Web Service (1) WSDL (1) Atlas (2) Business (76) Business Start-up Advice (25) Client (14) Expanding Your Business (17) C# (16) Canoeing (4) Canoe Racing (5) Cheshire Ring Race (5) Racing (2) Training (4) CIMA (1) Cisco (1) 7970G (1) CSS (3) dasBlog (4) DDD (1) Design (9) Icons (1) Development (12) General (39) Christmas (6) Fun and Games (11) Internet (22) Random (46) RX-8 (8) Home Cinema (2) Hosting (2) IIS (10) iPhone (1) JavaScript (4) jQuery (1) Marketing (5) Email (1) Multipack (1) Networking (2) Nintendo (1) OS Commerce (1) Photography (1) PHP (1) PowerShell (2) Press Release (1) Productivity (2) Security (2) SEO (5) Server Maintenance (4) Server Management (9) Social Media (1) Social Networking (2) Experiment (1) Software (9) Office (5) Visual Studio (12) Windows (4) Vista (1) SQL (1) SQL Server (13) Stored Procedure (1) Testing (1) The Site Doctor (104) Turnover Challenge (1) Twitter (2) Umbraco (17) 2009 (1) Web Development (54) WebDD (33) Wii (1)

Blog Archive

Search

<July 2010>
SunMonTueWedThuFriSat
27282930123
45678910
11121314151617
18192021222324
25262728293031
1234567

Recent Comments

Total Comments: 20
View all 20 comments

Blog Archive

Various Links

Blogs I Read

[Feed] Google Blog
Official Google Webmaster Central Blog
[Feed] Matt Cutts
Gadgets, Google, and SEO
[Feed] Ol' Deano's Blog
My mate Dean's blog on my space, equally as random as mine but not off on as much of a tangent!
[Feed] Sam's Blog
Sam is one of my younger brothers studying Product Design and Manufacture at Loughborough, this is his blog :) Enjoy!

Recent Tracks

last.fm - The Social Music Revolution

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

newtelligence dasBlog 2.2.8279.16125

Send mail to the author(s) Email Me (Tim Gaunt)

© 2010 Tim Gaunt.

Sign In

    # Tuesday, December 05, 2006

    Excel change case -sentance, proper, lower and upper

    Tuesday, December 05, 2006 2:38:04 PM (GMT Standard Time, UTC+00:00)

    Have you ever been sorting through a client’s product data and needed to change the case of the text? This is a great little add-in for Excel that can help.
    Download the zip file and run the xla file, you’ll then have a new option “Convert Text” under your “Tools” menu:

    Excel change case "Convert Text" Tool Menu

    To use it, select the text you want to change and then choose “Convert Text”, you can then choose from:

    • lower case
    • UPPER CASE
    • Proper Case
    • Sentence case

    It also has a number of other useful options like removing white space, adding characters etc.

    Excel Change Case Dialog Window

    Download the Excel Change Case Add-in here

    Excel change case -sentance, proper, lower and upper
    Useful Links:  #  digg it!  del.icio.us  Technorati  email it!  Post CommentsComments [2]  Trackback LinkTrackback
    CategoriesTags: Office
    Monday, July 20, 2009 5:09:42 PM (GMT Daylight Time, UTC+01:00)
    I love you.

    Thanks for this.
    Chantal
    Friday, October 16, 2009 10:41:42 AM (GMT Daylight Time, UTC+01:00)
    great app! thanks
    bob munton
    Name
    E-mail
    (will show your gravatar icon)
    Home page

    Comment (HTML not allowed)  

    Live Comment Preview
    Template based on a design by Arcsin. Valid CSS & XHTML. Crisis Cover - Business continuity support.