Concatenate cells with exponents as superscripts

[CJ]

Using Excel 2003, is it possible to concatenate cells containing exponents
without getting the carat? I don't want to concatenate 2 and the exponent 5
and get the result 2^5 when the 5 is already a superscript. The 5 needs to
remain as a superscript. Thanks.

 

[Stefan B Rusynko]

Suggest you ask in an Excel Newsgroup
- this is a FrontPage Newsgroup

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Using Excel 2003, is it possible to concatenate cells containing exponents
| without getting the carat? I don't want to concatenate 2 and the exponent 5
| and get the result 2^5 when the 5 is already a superscript. The 5 needs to
| remain as a superscript. Thanks.

 

[Wayne-I-M]

No - In excel you can't format a section of a cell (the same as an access
text box)

You can do it with a little vba module and call the module from the option
to redo your supercript (if there)

Try asking in the excel forum - this one if fror frontpage - some one will
give you the code there

Good luck

 

[Helpful person]

No - In excel you can't format a section of a cell (the same as an access
text box)

Yes you can.

While editing the cell highlight the characters you want to format.
Then from the menu choose format cells and choose the format you want
for those characters.

 

[Helpful person]

Using Excel 2003, is it possible to concatenate cells containing exponents
without getting the carat? I don't want to concatenate 2 and the exponent5
and get the result 2^5 when the 5 is already a superscript. The 5 needs to
remain as a superscript. Thanks.

You can format the cell as a string instead og numeric. Perfix the
input with the ' character.

 

[Wayne-I-M]

Are you sure ?

OK - You can click and drag to format

"BUT"

The OP was to concencate a cell - as far as I know you can't format sections
of a cell in a calculation without an public module call from the event (OK a
private Sub will do - if it's a One-Off but thats not normaly how excel is
used)

You may be right - I don't like excel - too many numbers - hurts my head

 

[Helpful person]

Are you sure ?

OK - You can click and drag to format

"BUT"

The OP was to concencate a cell - as far as I know you can't format sections
of a cell in a calculation without an public module call from the event (OK a
private Sub will do - if it's a One-Off but thats not normaly how excel is
used)

You may be right - I don't like excel - too many numbers - hurts my head

--
Wayne
Manchester, England.







- Show quoted text -

Yes I'm sure. You can easily try it yourself. In addition, anything
you can do on the keyboard you can do in visual basic for
applications. I haven't tried it but it may be possible to record a
macro to do it.

 

[Wayne-I-M]

Back to OP

Say you have a cell A1 and another A2
A1= 123
A2 = 456

=A1 & A2 = 123456

If A2 is superscript
A1 & A2 will "not" give you 123 (followed by superscrpit) 456

Which was the question in the OP.

I agree that using some simple vba you can get the result you want - but
this was not the OP

Think I will move this over to the excel forum - or the FP types will shout
at us

 

[Andrew Murray]

"concatenate" ???

 

[Wayne-I-M]

to join (not add) the contents of 2 sets of data

Sum =
123+456= 579

Concencate
123+456= 123456