Services & ResourcesWolfram ForumsMathGroup Archive

[Date Index] [Thread Index] [Author Index]

Exporting a formula to Excel via copypaste

• To: mathgroup at smc.vnet.net
• Subject: [mg125621] Exporting a formula to Excel via copypaste
• From: ruesche83 at gmail.com
• Date: Thu, 22 Mar 2012 05:50:26 -0500 (EST)
• Delivered-to: l-mathgroup@mail-archive0.wolfram.com

Hi there

I'm trying to copy a fromula from mathematica a and paste it to excel. It is a  polynomial. Something like:

-0.00488067+0.000981042 dff+0.000109406 dff^2+1.83066*10^-8

Now, there are two problems:
- The exponential is written as 10^-8. Which is not compatible with excel. This issue can be solve by using ScientificForm.
- The second problem: Excel wants asterisks (*) for the multiplication. This is solved by doing it this way: ScientificForm[rhofit, NumberMultiplier -> "*"]

Now, the problem is, that NumberMultiplier only adds asterisks where you have number, but not if you have variables. Any idea to replace the spaces with asterisks?

Any help would be highly appreciated.
Philipp

• Follow-Ups:
  • Re: Exporting a formula to Excel via copypaste
    • From: Bob Hanlon <hanlonr357@gmail.com>