CAPITALIZED ALL WORDS FROM WROKSHEET
dear sir,
i want to know that how can we change the all worksheet which is in small letter convert to capital letter? |
CAPITALIZED ALL WORDS FROM WROKSHEET
Although all caps isn't recommended for reading and screen size, you can use
the "upper" command. I usually have to do the opposite, with the "Lower", or sometimes the "proper" that capitalizes the first leter only. to convert text in a1, in a blank cell type "=upper(a1)" you can then drag the formula down or across. when you are finished, copy and paste values over the original. "convert all capital letter from excel" wrote: dear sir, i want to know that how can we change the all worksheet which is in small letter convert to capital letter? |
CAPITALIZED ALL WORDS FROM WROKSHEET
The free Excel add-in "Excel Extras" will do that and more.
Download from... http://www.realezsites.com/bus/primitivesoftware -- Jim Cone San Francisco, USA "convert all capital letter from excel" wrote in message dear sir, i want to know that how can we change the all worksheet which is in small letter convert to capital letter? |
All times are GMT +1. The time now is 07:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com