formla to calculate the max min sum average of a range with data separated by space

[bezbid]

Book1
	A	B	C	D	E	F
57					A B
58					2.27% -3169
59					0.63% 2685
60					1.61% -966
61					0.48% 1224
62
63					0.88% 2493
64					0.28% -187
65					1.31% 2404
66					2.00% -2444
67					1.65% 5776
68					0.98% -1112
69
70
71		Max A
72		Min A
73		Sum A
74		Average A
75
76		Max B
77		Min B
78		Sum B
79		Average B
80
Sheet1

How to get the Max, Min, Sum, average of the respectives as in the table, which is separated by a space, thanks

 

[jdellasala]

Like this:

Book1
	B	C	D	E
1				A B
2				2.27% -3169
3				0.63% 2685
4				1.61% -966
5				0.48% 1224
6
7				0.88% 2493
8				0.28% -187
9				1.31% 2404
10				2.00% -2444
11				1.65% 5776
12				0.98% -1112
13
14
15	Max A	2.27%
16	Min A	0.28%
17	Sum A	12.09%
18	Average A	1.21%
19
20	Max B	5,776
21	Min B	-3,169
22	Sum B	6,704
23	Average B	670
Sheet2

Cell Formulas
Range	Formula
C15	C15	=MAX(IFERROR(VALUE(LEFT($E$2:$E$12,SEARCH(" ",$E$2:$E$12))),""))
C16	C16	=MIN(IFERROR(VALUE(LEFT($E$2:$E$12,SEARCH(" ",$E$2:$E$12))),""))
C17	C17	=SUM(IFERROR(VALUE(LEFT($E$2:$E$12,SEARCH(" ",$E$2:$E$12))),""))
C18	C18	=AVERAGE(IFERROR(VALUE(LEFT($E$2:$E$12,SEARCH(" ",$E$2:$E$12))),""))
C20	C20	=MAX(IFERROR(VALUE(RIGHT($E$2:$E$12,LEN($E$2:$E$12)-SEARCH(" ",$E$2:$E$12))),""))
C21	C21	=MIN(IFERROR(VALUE(RIGHT($E$2:$E$12,LEN($E$2:$E$12)-SEARCH(" ",$E$2:$E$12))),""))
C22	C22	=SUM(IFERROR(VALUE(RIGHT($E$2:$E$12,LEN($E$2:$E$12)-SEARCH(" ",$E$2:$E$12))),""))
C23	C23	=AVERAGE(IFERROR(VALUE(RIGHT($E$2:$E$12,LEN($E$2:$E$12)-SEARCH(" ",$E$2:$E$12))),""))

Of course, it is always better to clean up the source data first, but whatever!
Thanks for using XL2BB!