R
Ray Ray
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
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