[EXCEL Tutorial]Change Text In Upper Case Of Multiple Cells In Excel
Softwaresall type of software tutorials
Notices
You are currently viewing AIOFORUM as a guest which gives you VERY limited access to view most discussions, Applications, Latest Movies & Tutorials and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload and Download content and access many other special features. Registration is fast, simple and absolutely free so please, Join our community today!
[EXCEL Tutorial]Change Text In Upper Case Of Multiple Cells In Excel -
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.
The Following 4 Users Say Thank You to vj_ip For This Useful Post:
[EXCEL Tutorial]Change Text In Upper Case Of Multiple Cells In Excel -
01-24-2008, 07:02 AM
Linear Mode
Similar Threads
