ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is there a way to have "subscripts" in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/35775-there-way-have-%22subscripts%22-excel.html)

Sam

Is there a way to have "subscripts" in Excel?
 
Hello,

I need to type the following in one of the cells:
E(Ut), where "t" stands for time, and it is formatted to be a Subscript.
MS-Word even has a toolbar button that makes text "subscript". However, when
I paste this text into Excel, the subscript formatting disappears.

Is there a way to format some of the text in a cell as subscript?

Thank you!

Paul B

Sam, highlight the t then format, cells, font, check subscript

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Sam" wrote in message
...
Hello,

I need to type the following in one of the cells:
E(Ut), where "t" stands for time, and it is formatted to be a Subscript.
MS-Word even has a toolbar button that makes text "subscript". However,

when
I paste this text into Excel, the subscript formatting disappears.

Is there a way to format some of the text in a cell as subscript?

Thank you!




Jim Rech

Select the part of the text you want subscripted. Then press Ctrl-1 and
check the Subscript checkbox, close the dialog and press Enter.

--
Jim
"Sam" wrote in message
...
| Hello,
|
| I need to type the following in one of the cells:
| E(Ut), where "t" stands for time, and it is formatted to be a Subscript.
| MS-Word even has a toolbar button that makes text "subscript". However,
when
| I paste this text into Excel, the subscript formatting disappears.
|
| Is there a way to format some of the text in a cell as subscript?
|
| Thank you!



Dave Peterson

John Walkenbach has a helpful addin that you may like:
http://j-walk.com/ss/excel/files/supersub.htm

Sam wrote:

Hello,

I need to type the following in one of the cells:
E(Ut), where "t" stands for time, and it is formatted to be a Subscript.
MS-Word even has a toolbar button that makes text "subscript". However, when
I paste this text into Excel, the subscript formatting disappears.

Is there a way to format some of the text in a cell as subscript?

Thank you!


--

Dave Peterson


All times are GMT +1. The time now is 07:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com