View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ray Ray Ray Ray is offline
external usenet poster
 
Posts: 1
Default Use Formula to sort two strings

Dear experts

I design the following spreadsheet. Please advise how I can achieve the
result on column C (i.e. it sorts column A and B in ascending order, and puts
the smaller string in the front and the bigger one at the back)?

A B C
1 Atlanta Los Angeles Atlanta-Los Angeles
2 Orlando Chicago Chicago-Orlando
3 Mexico City Miami Mexico City-Miami


--
Best regards
Ray Ray