Re: Exporting a formula to Excel via copypaste

*To*: mathgroup at smc.vnet.net*Subject*: [mg125628] Re: Exporting a formula to Excel via copypaste*From*: A Retey <awnl at gmx-topmail.de>*Date*: Fri, 23 Mar 2012 01:31:19 -0500 (EST)*Delivered-to*: l-mathgroup@mail-archive0.wolfram.com*References*: <jkf09d$8kq$1@smc.vnet.net>

Hi, > 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? I would suggest to start from either CForm or FortranForm and adjust the details with StringReplace, e.g. the following should work: StringReplace[ ToString[FortranForm[-0.00488067 + 0.000981042 dff + 0.000109406 dff^2 + 1.83066*10^-8 dff^3]], {"**" -> "^","dff"->"A1"} ] which will result in: "-0.00488067 + 0.000981042*A1 + 0.000109406*A1^2 + 1.83066e-8*A1^3" which I think excel should accept as a formula (at least it did for after removing for the double quotes and replacing . with , since I have a German version)... hth, albert