98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Spelling/mixed casing
Spelling/mixed casing
Resolved · Low Priority · Version 2003
Thu 24 Sep 2009, 16:18Delegate Liz said...
Liz has attended:
Excel Intermediate course
Spelling/mixed casing
How do I correct spelling mistakes or introduce toggle casing or upper case where it didn't exist on the spreadsheet?
Mon 28 Sep 2009, 10:50Trainer Andrew said...
RE: Spelling/mixed casing
Hi Liz
Thank you for your question. There are three Excel functions that can help:
UPPER()
LOWER()
PROPER()
They return uppercase, lowercase or Title Case results. Just create a formula using the relevant function eg =PROPER(A1) Turns text in A1 to Title Case (words with capital initials)
or LOWER("SOME TEXT") would produce the result:
some text
Beyond that we would need to create a macro to make changes (e.g. capitalise the first word of every sentence)
I hope this helps.
Kind regards,
Andrew
Mon 5 Oct 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Shortcuts for working with named ranges in ExcelIf you are working with or creating named ranges in your spreadsheets, then you may find the following shortcut keys useful. |
