Posted to microsoft.public.excel.worksheet.functions

JE McGimpsey

Posts: n/a

change the case of all the text in a coloumn

See

http://www.mvps.org/dmcritchie/excel/proper.htm#upper

Or

Use

B1: =UPPER(A1)

Copy down as far as necessary. Copy column B. Select Column A. Choose
Edit/Paste Special, selecting the Values radio button.

In article ,
excel_ppl wrote:

trying to change the case of all the test strings in a column to UPPER case

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
VBA	Monty	Excel Worksheet Functions	2	January 30th 06 01:37 PM
convert numbers to text	bellman	Excel Discussion (Misc queries)	0	October 4th 05 10:28 PM
EXCEL:NUMBER TO GREEK WORDS	vag	Excel Worksheet Functions	1	June 15th 05 05:57 PM
reminder notifications in a column	L Mieth	Excel Discussion (Misc queries)	6	June 10th 05 11:00 AM
How do I change the case of text	date formats morph the dates/chang case	New Users to Excel	2	April 18th 05 10:15 PM

All times are GMT +1. The time now is 06:45 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us