Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - Capital letter conversion
Resolved · Low Priority · Version Standard
Lyndsey has attended:
Excel Advanced course
Is there a way in excel to convert words written in capital letters to lower case????
thanks
Dear Lyndsey
Thank you for attending Excel Advanced Course.
Yes it is very simple to convert the UPPER CASE to lower case.
Please refer to the excel file that I have uploaded with this post.
A3:A12 is the original text typed in capital letters
Step 1: Enter the Function in B3 =LOWER(A3)
Step 2: Use the fill handle (the black small square at the bottom right corner of cell B3) and dragged it down until B12.
It should do the trick but what you
|
Excel tip:Use the Ctrl-key for quick navigation in Excel 2010If you want to move quickly to the right, left, top or bottom of your spreadsheet, just press Ctrl and one of the arrow keys. If you want to then select all the data in that particular row or column, hold down the Shift key and press Ctrl and an arrow key. |
We'll call during UK business hours
Server loaded in 0.08 secs.