I HAVE SALES DATA IN COLUMNS C,D AND E AND MY ON HAND COUNT IN COLUMN
F. THE DATA IN MOSTLY 2 DIGIT WITH SOME 5 DIGIT BUT NOTHING ABOVE 5
DIGIT. THE FORMULA BELOW IS IN COLUMN H. I AM GETTING THE CORRECT
RESULTS FROM THE FORMULA BUT BECAUSE OF THE RESULTANT DIGIT COUNT
ASSOCIATED WITH EACH PART OF THE FORMULA THE TEXT DOES NOT ALIGN AS I
WOULD LIKE. I NEED TO TAB OR "PAD" THE RESULTS SO THEY ALIGN IN A MORE
READABLE FORMAT.

=("MAX"&" "&(MAX(C3:E3)))&" "&("MIN"&" "&(MIN(C3:E3)))&" "&("AVG"&"
"&(AVERAGE(C3:E3)))&" "&"ON HAND"&" "&F3. I KNOW IT IS UGLY BUT IT
WORKS!

REGARDS

BIG D