title: Excel formula to take values from cell range, sort alphabetically and write as a single string
body: <p>I currently have a list of translators and the languages they can speak: </p>
  
  <pre><code>  |   A   |     B      |     C      |     D      |             F             |
    +-------+------------+------------+------------+---------------------------+
  1 | Name  | Language 1 | Language 2 | Language 3 | Combined                  |
    +=======+============+============+============+===========================+
  2 | John  | English    | Chinese    | Spanish    | English, Chinese, Spanish |
  3 | Wendy | Chinese    | French     | English    | Chinese, French, English  |
  4 | Peter | Spanish    | Chinese    | English    | Spanish, Chinese, English |
  </code></pre>
  
  <p>In column F I am using the following formula to combining all the languages for each person together:</p>
  
  <pre><code>=$B2&amp;", "&amp;$C2&amp;", "&amp;$D2
  </code></pre>
  
  <p>I am using this column in a pivot table to report on people who can speak the same combination of languages. My problem is, if the languages are entered in a different order (e.g. row 2 and 4) the report shows up as a different combination. Is there a formula I can use to take the three language cells, sort them alphabetically and the write it out as a string?</p>
  
  <p>Hope this is clear.</p>