sort multiple rows without affecting others rows

I want to sort each row in an excel sheet so all calls are in alphabetical
order without affecting any other row. I need to do this for about 500 rows.
Is there any quick way of doing this without having to sort each row
individually

Originally Posted by Nitya

I want to sort each row in an excel sheet so all calls are in alphabetical
order without affecting any other row. I need to do this for about 500 rows.
Is there any quick way of doing this without having to sort each row
individually

I want to know how to do this too! Doesn't bode well that no-one's responded to you in 6.5 years! You only have 500 rows, I have over 11,000!

It's alright, I did some googling. Something called the small function does the job!