TechWhirl (TECHWR-L) is a resource for technical writing and technical communications professionals of all experience levels and in all industries to share their experiences and acquire information.
For two decades, technical communicators have turned to TechWhirl to ask and answer questions about the always-changing world of technical communications, such as tools, skills, career paths, methodologies, and emerging industries. The TechWhirl Archives and magazine, created for, by and about technical writers, offer a wealth of knowledge to everyone with an interest in any aspect of technical communications.
Jean Cooper wrote:
>
> I hope this is an easy question:
>
> How can I change a column of text data from lowercase to all-caps? (Other
> than re-typing it, of course.) I know in Word you just highlight the
> selection and then hit Shift-F3. But I can't find any way of doing it in
> Excel.
>
> Can anyone help?
>
All you need to do is find an empty column and enter this formula in
that column without the quotes. =UPPER() the space between the
parentheses should reference the cell that you wish to convert to
uppercase. Just copy that formula down the entire empty column. Then
select the new column that you have just created and do a copy and paste
special | "values." These instructions work for XL 2000, I have not
tested them with another version however it should be the same.
Alternatively, you could write a VBA macro to search through the entire
spreadsheet and convert all instances of lowercase to uppercase. You may
then assign the macro to a key.
HTH
--
Peter
There are few situations in life that cannot be resolved
promptly, and to the satisfaction of all concerned,
by either suicide, a bag of gold,
or thrusting a despised antagonist over a precipice on a dark night.
Ernest Bramah (Kai Lung stories)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Learn how to develop HTML-based Help with Macromedia Dreamweaver!
Dec. 7-8, 2000, Orlando, FL -- $100 discount for STC members. http://www.weisner.com/training/dreamweaver_help.htm or 800-646-9989.
Sponsored by SOLUTIONS, Conferences and Seminars for Communicators
Publications Management Clinic, TECH*COMM 2001 Conference, and more http://www.SolutionsEvents.com or 800-448-4230
---
You are currently subscribed to techwr-l as: archive -at- raycomm -dot- com
To unsubscribe send a blank email to leave-techwr-l-obscured -at- lists -dot- raycomm -dot- com
Send administrative questions to ejray -at- raycomm -dot- com -dot- Visit http://www.raycomm.com/techwhirl/ for more resources and info.
