Text as part of Cell Format

G

Guest

I want to create a "superscript" B and Superscript F as part of the cell
formating in an excel sheet. Data has already been entered into the cells,
and I want to avoid having to re-enter each cell, type the letter B or F,
change to superscript for every entry. Is there a way to automate this
process, and avoid deleting the data that is in the cell already?
 
E

Earl Kiosterud

Evan,

A macro is the way to go. If you're willing, we'll write you the macro.
This won't work with cells containing formulas or numbers. Text only. If
it's numbers, it'll become text when we append the superscripted BF stuff.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Superscript in Custom Format 2
Macro to change part of cell 2
how do i superscript part of a cell in MS Excel? 8
How do I format part of a text cell, but not the whole thing? 2
Superscripting text in a cell 1
How do I format text that is part of a formula? 5
How format partially one text cell for font, etc., but not whole c 2
& function cell format translation. 3

Top