Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro to change part of cell
Hi,
I often need to change the formatting of only part of a cell - e.g. for the units ug s-1, where the -1 is superscript and the u is actually the Greek letter mu (m in Symbol font). I know how to do both these things via the "format cells" dialog box, but would like a keyboard shortcut to do them quickly. I tried to record a macro to change to superscript and another to change to Symbol font, but these change the formatting of the whole cell. When I select just the characters whose format I want to change, the 'macros' option is greyed out. How can I run a macro on only part of a cell, or else is there another way to achieve this with a keyboard shortcut? Ideally I would like to apply this to chart titles as well. I'm using Excel 2003. Thanks, Amy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro to move part of cell contents to another cell | Excel Discussion (Misc queries) | |||
Replace Old Part Numbers with New Part Numbers in a Macro. | Excel Discussion (Misc queries) | |||
excel - create a macro to use cell text as part of a file name | New Users to Excel | |||
Using macro to copy a part of a cell content to next cell | Excel Discussion (Misc queries) | |||
Keeping one part of a formula same, but change other cell ref? | Excel Discussion (Misc queries) |