Apple Intelligence is now available on iPhone, iPad, and Mac!
I have 2 alpha cells and I want a third cell to combine the 2 with the letters to be in order by cell. Ie if I have “DEC” in the first cell and “ABF” I the second cell I want the third to read “ABF DEC”
i have this code to combine but need to order them: ""&1stCell&""&" "&""&2ndCell&""
where the 1stCell and 2ndCell is the actual cell code
please help
iPad, iPadOS 17
If I understand the ask correctly, you want the third field to combine the other two fields in alphabetical order, right?
There is no built-in sort function at this level, but if you're just dealing with a couple of fields, a simple IF() statement should suffice.
A2<B2 will return TRUE if A2 is alphabetically lower than B2, or FALSE if it's greater. This can be used in an IF() statement:
=IF(A2<B2, A2 & " " & B2, B2 & " " & A2)
so IF() A2 is less than B2, it returns A2 & " " & B2, otherwise it returns B2 & " " & A2
Here is an example of what you could do:
Order function for two cells. Combined into one
