Thanks Rob,KK,BryanD,Stovetopp,Woof et Jaz U2
I went the following route. Mission accomplished afaic
.
From hands 50,000 to 97,000+, the Dealer's largest number of cards in a single hand was 7. Thus, I used KK's "IF formula's" to assign values to the 3 face cards as well the T or 10 card so there were actually 5 Cards represented by Text rather than the 4 KK mentions. KK was still the Keyman to my ~90% more efficient solution for now.
Since the largest number of cards in a hand is 7 in the current group, I had to set up 5 text to numbers formulas for each card for a total of 35 in a row of cells plus a 36th formula that merges and totals the 35 converted text to number values with the original numbers as listed in the provided hand histories.
As far as the ACES, I used my own fully certified and tested by Bear Stearns, AIG, and Lehman Bros., 125 year old RNG that has been preserved in both the vaults of Wachovia and WaMu to insure 100% fairness. The RNG determined the value for the ACES. The number was neither 1 or 11 but one can not argue with the RNG as the number was 111. Must be a minor glitch but not a big deal. Afterall, 111 is really the same as 1 and 11
.
With the just kidding aside, I will now simply go adjust all hands that had ACES accordingly and used 111 for all ACES so those hands requiring manual adjustment would be obvious and easy to recognize. Thus, with the help I received the time necessary to complete organizing the data (I have,hurry please with the balance) has probably been reduced by ~90% as previouly mentioned.
Once I complete organizing the data , then simple but important BJ analysis such as BJ's, 2 Card 20's, Dealer Upcard Distribution, Dealer Final Totals, Win/Lose/Push %'s*, Bust Rates*, Etc.,can proceed. Furthermore, where applicable for both the dealer and/or player the results can be compared to known statisical expectation. This can all be done very quickly.
Other analysis will take more time for several reasons.
I also will have to remove my played hands that deviate (guessing a few hundred hands out of 100,000 plus) from Basic Strategy (see prior asterisks above also). My BS deviation occurs at times from just playing too fast, visiting LaLa Land on occasion, sometimes on purpose by moi and a 4th reason beyond any player's control.
A small sample below of how the data looks after the sample formulas were posted by KK and the dummie (moi) ran with them,lol....The totals on the right took about 20 minutes to total 47,000 hands once the formulas were completed........The numbers on the left about 8 or 9 hours to manually total row by row ~10,000 hands with ~ 90,000 remaining prior to today. Many thanks
Qh,Kc
20
20
2c,4d,3d,8s
17
17
As,9h
20
120
Td,3s,Qd
23
23
6c,2d,Kd
18
18
Ks,As
21
121
2h,8c,Jc
20
20
) if possible with a hand history to convert text or a string of text in a column to numeric values so I do not have to keep totaling each hand (over 100K total hands/rows) row by row. A sample of 10 rows and 2 columns (not aligning) below: 
