Formula or Function to Reorder Values or Text Strings

Greetings everyone,
Thank for taking your time to view this thread. I am looking for a formula or function to reorder the text string "TRUE" and "FALSE", so they all are in the same order
The final result that I'm looking for is as follow:
% TRUE, % FALSE
% TRUE, % FALSE
% TRUE, % FALSE
Please take a look at the attached document for sample.
Again thank you for much for your time and dedication to this wonderful forum.

Given your data in col A beginning in A2, try

B2: =IF(COUNTIF(A2,"*,*"),IF(COUNTIF(A2,"* TRUE,*"),A2,REPLACE(A2,1,FIND(",",A2)+2,"")&", "&LEFT(A2,FIND(",",A2)-1)),IF(COUNTIF(A2,"* TRUE*"),"100.00% TRUE, 0.00% FALSE","0.00% TRUE, 100.00% FALSE"))

This always produces both TRUE and FALSE parts, so 100.00% TRUE, 0.00% FALSE and 0.00% TRUE, 100.00% FALSE.

Originally Posted by Rick Rothstein

Give this formula a try (put it in cell B2 and copy down to the end of your data)...

Formula:

Please Login or Register  to view this content.

Actually, this shorter formula works the same as the above formula...

Formula:

Please Login or Register  to view this content.

Originally Posted by hrlngrv

This always produces both TRUE and FALSE parts, so 100.00% TRUE, 0.00% FALSE and 0.00% TRUE, 100.00% FALSE.

If you are correct about the OP wanting TRUE/FALSE percentages even for 100% conditions, then here is a slightly more compact formula that produces the same output that your formula does...

Formula:

Please Login or Register  to view this content.

Going for brevity? Note that all original entries have 2 spaces between % and T or F. If we should preserve that formatting too,

=IF(LEFT(A3,3)="100",REPLACE("0.00% TRUE, 0.00% FALSE",1+(MID(A3,7,1)="F")*14,0,10),MID(A3&", "&A3,1+COUNTIF(A3,"*F*,*")*(FIND(",",A3)+2),LEN(A3)))

is just a bit shorter. Then again, Excel stinks at text processing. Better to use Google Sheets, in which this could be done using

=if(left(A3,3)="100",replace("0.00% TRUE, 0.00% FALSE",1+countif(A3,"*F*")*14,0,10),regexreplace(A3,"(.+F.+), *(.+)","$2, $1"))

Someday Excel may support regular expressions.

Originally Posted by hrlngrv

Note that all original entries have 2 spaces between % and T or F.

I completely missed that!

Originally Posted by hrlngrv

Someday Excel may support regular expressions.

Yes, that would be nice.