How do I alphabetize & concatenate cells & maintain row integrity
 

I need a formula to alphabetize and concatenate the contents of 2 cells

How do I alphabetize & concatenate cells & maintain row integrity
 

Will this answer your need?
=IF(A1B1,A1&B1,B1&A1)
best wishes
--
Bernard Liengme
http://people.stfx.ca/bliengme
Microsoft Excel MVP

"D_B" wrote in message
...
I need a formula to alphabetize and concatenate the contents of 2 cells

How do I alphabetize & concatenate cells & maintain row integrity
 

Did you try the Concatentate Excel Function?

"D_B" wrote:

I need a formula to alphabetize and concatenate the contents of 2 cells

How do I alphabetize & concatenate cells & maintain row integrity
 

Try the below with data in A1 and A2

=IF(A1A2,A2&A1,A1&A2)

If this post helps click Yes
---------------
Jacob Skaria


"D_B" wrote:

I need a formula to alphabetize and concatenate the contents of 2 cells