Question for excel experts

Reply #6

retxx — Fri, 09 Feb 2007 03:45:38 GMT

thanks Mickie,looking forward to good results I hope.

Reply #5

Mickie — Thu, 08 Feb 2007 22:49:51 GMT

SirMetro

Wow!! Thank you!

There is a small problem though, I did fix one part(I took and made them individual in cells)

see what the last number is? A 3 digit.

0027

5196196196156152152452422422422722702707707

Here is the original:

00275196 - 1961 - 9615 - 6152 - 1524 - 5242 - 2422 - 4227 - 2270 - 2707 - 707

The purple is the number I want to Sq root.

Retxx as soon as I finish I will send you a copy.

Mickie

Reply #4

SirMetro — Thu, 08 Feb 2007 13:51:20 GMT

Here is the Macro that will function IF your primary number is in Cell A1

=CONCATENATE(LEFT(TEXT((SQRT(A1)*1000000000000), ############### ),4), - ,MID(TEXT((SQRT(A1)*1000000000000), ############### ),2,4), - ,MID(TEXT((SQRT(A1)*1000000000000), ############### ),3,4), - ,MID(TEXT((SQRT(A1)*1000000000000), ############### ),4,4), - ,MID(TEXT((SQRT(A1)*1000000000000), ############### ),5,4), - ,MID(TEXT((SQRT(A1)*1000000000000), ############### ),6,4), - ,MID(TEXT((SQRT(A1)*10000000... [ More ]

Reply #3

retxx — Thu, 08 Feb 2007 04:05:32 GMT

hey mickie i am not very good at macros so could you or someone set up the macro in a spreadsheet so I can download it and see ifit works.Thanks

Reply #2

Mickie — Wed, 07 Feb 2007 00:30:02 GMT

Thank you!

You got my mind a flowing. Here is what happened and what I ended up with. Hope others enjoy on their endeavors of the sqrt and PI they are working on.

Original #

6082What it gave me

779877798.71784333817798798.98.78.71.7177178178478438433433333383381

What I wanted77987987987187177178178478438433433333383381

7798717843338177987987987187177178178478438433433333383381

Left7798

Right7178433381

Concentrate77987178433381

NEW=CONCATENA... [ More ]

Reply #1

phileight — Tue, 06 Feb 2007 22:55:26 GMT

Mickie

let me assume your # is in a1 you want your result to be in c1 and you want the 4 # starting at position 5

in c1 type =mid(a1,5,4) cell a1 start position 5 4 #

enjoy

p8

Question for excel experts

Mickie — Tue, 06 Feb 2007 21:10:41 GMT

Every one is doing, Square roots Pi's.

My number is 6082 and I did a square root which equals 7798.7178433381

Now I want to make these new numbers:

7798 - 7987 - 9871 - 8717 - 7178 - 1784 - 7843 - 8433 - 4333 - 3381

What I did was to take the first 4# then the next 4#, etc

What formulas would I use to extract these.

Thank you

Mickie