One could make a UDF (user defined function) Are you ready to explore VBA?
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"scidoc" wrote in message
...
I have a row of 6 random ordered numbers. I with to find out how to
automatically copy them into another row and have them in Ascending
numerical
order. I'm at a loss to figure out what function can do this.

Example:
Input 9 4 56 8 2 27

Output 2 4 8 9 27 56

Thanks, Scidoc