instead of using small function, you can use sort function.
ex. =SORT(C2:E2,1,1,TRUE)
and than you can drag and copy per row.
C2:E2 --> column to be sort
1 --> index
1 --> ascending
True --> sort by column

I cannot thank you enough for this. I've watched youtube videos, read posts, and none of them seemed to understand how I needed to sort each row individually and instantly without also rearranging the others. I gathered two years worth of numeral data for a personal project and it was a big mess! Tens of thousands of rows! I needed the numbers separate in individual cells (originally they weren't, but thats a whole other story!), and now I also needed them in order per row! First I tried simply going row by row, copying, deleting, retyping, pasting; but it was TEDIOUS. Then I tried transposing the tables, sorting-by-ascending column, one by one copying the column, and repasting into a blank chart, then transposing the new chart and copying all, and then pasting back into the original chart; but again - TEDIOUS. Now I will just create an adjacent chart using the formula, copy, paste, DONE!!!!!!!!!!! YAY!!!!!!!! :) THANK YOUUUU :)

AHA! - right! - I know WHAT i need to do - now I just need to learn how to write the blimming macro to: set up a do-while loop to trip down the rows until a blank entry is found (end of range):for each populated cell found; select first cell to be processed:Assign value of target cell to a variable: Insert temporary new first row>insert temp new column 'a': copy and paste value into cell A1; convert text to columns; select generated values; cut and paste special (transpose) into temp column A; sort column a in ascending order; insert a concatenation formula into the original cell to capture values in A1&A2&A3 etc; (probably using another loop to capture populated cell values) copy and paste special (values) into original cell; remove temp column: remove temp Row A: select next cell and repeat the loop. Sounds simple enough ...

Great - now then: How can I sort multiple rows of TEXT values alphabetically - (something akin to the 'Small' function that will work with text values? - The sorting each row individually method works - but since I have over 6 thousand rows - and zero boredom threshold - I'm hoping that someone has managed to put together a formula solution (ideally) of a maco tool?

Says you're going to show us how to sort alphabetically then you only use numbers.