I need some assistance with MS Excel. First, a little bit about me (the user). I am an very advanced user of Excel (and computers in general). My
only reason for mentioning this is not to toot my horn, but rather to be very specific about what I am trying to accomplish here. What I am trying to
do is very, very, specific, and there are a whole lot of things (easier explanations) which I am NOT trying to do.
- I have a VERY large number (quite possibly the single largest number in the universe...Pi). I am trying to parse this number. I am
principally interested in ONLY the non-terminating, non-repeating, decimal portion of Pi (i.e. the x.1415976... portion, not the '3.x' part). (I can
deal with the '3' if I have to, but this is not what I'm interested in). I would like to parse the decimal portion of Pi up into 2 digit strings
(i.e. 14, 15, 92, etc.). I am working with roughly 1,000 digits behind the decimal point (more if I can figure out how to do this). I need an
automated way to parse the decimal portion of Pi in this manner. But there's more... I then want to do the same thing again (another iteration) in
groups of 3 digit strings (i.e. 141, 592, etc.). And again, in groups of 9 digits, 10 digits and 12 digits.
As mentioned, I am working with 1,000 to 5,000 places behind the decimal (a very large string indeed, right). I also want to take the result of each
iteration and have it appear in a separate row (not column) of one column in the spreadsheet (getting the results into a column can be a separate
step). In other words, I want the result of the 2 digit parse to appear as a series of rows in one column, and the result of the 3 digit parse as a
series of rows in another column and the same for the 9, 10 and 12 digit parses.
Things I have already tried / other considerations -
First, there are NO spaces or delimiters of any kind in the raw starting number, just a
gi-normous string which goes on for thousands of digits. I have already tried "Text to Columns", and this works, BUT it is far too tedious for what
I'm trying to do because you have to set each parse point manually (I'm looking for an automated way to tackle this). I've tried the "LEFT, RIGHT,
MID" function, and there may be a solution with this, but I haven't discovered it so far (hopefully you may know a way). Everything I've tried with
this function really wants a space or some form of a delimiter to work properly.
I will likely want to do other iterations beyond those mentioned in the future, so some flexibility and ease of use would be great.
Example starting point -
As an example, my starting point will look something like this...in cell A1 I will have a 1,000 digit number. If I
were to use "Text to Columns" and 2 digit parse for 100 parses I would then have cell A1=14, cell A2=15, cell A3=92 and so on for 97 more columns. My
ideal end configuration would be to then make all of those columns into rows, so cell A1=14, cell B1=15, cell C1=92 and so on for 97 more rows.
I've found all manner of videos and instructions on how to parse lists of peoples names for example, but this is not what I'm trying to
do. Plus, all of those usually have a space, comma or some other form of a delimiter which makes things much easier, not to mention these are usually
already in row orientation when the parsing begins. I don't have this luxury.
There is a reward for your help even! If my theories are correct, and you help me prove them by getting me to a good starting point,
your reward just may be that you will have the satisfaction of being part of...SAVING ALL OF HUMANITY! (I know, it's a crummy reward, but it's
something). Seriously though, this may actually have some pretty revolutionary outcomes possibly bordering on rewriting some elements of mathematics
Any help you can provide, ATS, would be GREATLY appreciated!!!
P.S. I can't think of a smarter group of folks to ask this question to.
edit on 5/1/2016 by Flyingclaydisk because: (no reason given)