Services & Resources / Wolfram Forums / MathGroup Archive
-----

MathGroup Archive 2012

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

Search the Archive

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



  • Prev by Date: Re: Different Color in ToString
  • Next by Date: Re: Different Color in ToString
  • Previous by thread: Roman Maeder and Computer Science with Mathematica
  • Next by thread: Re: Exporting a formula to Excel via copypaste