Unable to sort a cell containing text

  • Try this

    - the text in cell AF1 is copied to A1 in a temporary sheet

    - row1 used to accomodate TextToColumns split of the text

    - the data is then transposed to column A and sorted

    - sorted data is concatenated with space between each word and written back to AF1

    - temporary sheet is deleted