[EXCEL Tutorial]Change Text In Upper Case Of Multiple Cells In Excel - Free Full Direct Download Forum Rapidshare Links

vj_ip · 01-24-2008, 07:02 AM

To make these cells lowercase in Excel 2003 and earlier versions of excel, follow these steps:

Insert a column to the right of column A by selecting column B and clicking Columns on the Insert menu.
Type the following formula in cell B1:
=LOWER(A1)
Select the column
On the Edit menu, point to Fill, and then click Down.
The new column now contains the lowercase version of the text in column A.
With the same range selected, click Copy on the Edit menu.
Select cell A1, and click Paste Special on the Edit menu. Under Paste, click Values, and click OK to paste the converted values back on top of column A.
Delete column B by selecting the column and clicking Delete on the Edit menu.

zarazara33 · 06-21-2008, 02:57 AM

thanks for the tip !!

01-24-2008, 07:02 AM	#1 (permalink)
vj_ip User Info Join Date: Sep 2007 Achievements Posts: 10 Casino Cash: $3900 Total Points: 4,827.48 Donate Reputation: 3210	[EXCEL Tutorial]Change Text In Upper Case Of Multiple Cells In Excel To make these cells lowercase in Excel 2003 and earlier versions of excel, follow these steps: Insert a column to the right of column A by selecting column B and clicking Columns on the Insert menu. Type the following formula in cell B1: =LOWER(A1) Select the column On the Edit menu, point to Fill, and then click Down. The new column now contains the lowercase version of the text in column A. With the same range selected, click Copy on the Edit menu. Select cell A1, and click Paste Special on the Edit menu. Under Paste, click Values, and click OK to paste the converted values back on top of column A. Delete column B by selecting the column and clicking Delete on the Edit menu.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel for the CEO	Nawainruk	Ebooks,tutorials & Other Stuff	1	01-15-2008 07:18 AM
Create For Excel 3.0.0.322	KoOL	Appz Zone	0	11-28-2007 02:12 PM
Assist For Excel 1.6.0.586	KoOL	Appz Zone	0	11-28-2007 02:10 PM
Integrating Excel and Access	ijhtio	Ebooks,tutorials & Other Stuff	0	11-02-2007 03:03 PM
Excel Business Tools	sharad_mlk	Appz Zone	0	05-27-2007 02:26 AM

New To AiO Forum?	Need Help?
Review Our Site Rules Are you inaccessbile to Forum? Meet Our Staff Aio Forum's Disclaimer? Did you forget your password?	Mark Forums Read Why Donate Money To AIO Forum? How to View Links after Pressing Thanks Button How to Code Links

06-21-2008, 02:57 AM	#2 (permalink)
zarazara33 User Info Join Date: May 2008 Achievements Posts: 65 Casino Cash: $4650 Total Points: 1,621.55 Donate Reputation: 113	thanks for the tip !!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)