Thread: How do I alphabetize & concatenate cells & maintain row integrity
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default 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

Reply With QuoteReply With Quote