How do I copy text formatting using a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Yes I know, a similar question appears in the database. My problem is that I
can't use custom formatting. Here's the deal. I want to copy
1s(superscript)1 from one cell to another. But it's a variable entry and
could turn into a longer expression, such as 1s(ss)22s(ss)2sp(ss)3 for
example. (More clearly perhaps, 1s^22s^2sp^3) How do I do this? Thanks!
 
Formulas can't change formatting like this. And even worse, formulas can't be
formatted this way at all--even manually.

You could use an event macro that looks for changes to that cell and copies the
cell to the other location.

Post back with some details if you want to try it and need help.
 
(Sigh) I was afraid of that. Thank you anyway!

Dave Peterson said:
Formulas can't change formatting like this. And even worse, formulas can't be
formatted this way at all--even manually.

You could use an event macro that looks for changes to that cell and copies the
cell to the other location.

Post back with some details if you want to try it and need help.
Click to expand...
 

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

How do I count the number of each number in a column? 5
copy a range without the same value 1
EXCEL: how do I add multiple one digits in a singe cell? (tally) 3
How do I count the frequency of a given number in a column? 6
Macro to copy a worksheet and rename based upon text entered in 1 5
Time Format 4
How to import data from text file 1
Can I recognize the specific letters in a cell using formulas? 3

Back
Top