Unable to sort a cell containing text

  • Good evening all


    In my file I have hidden cell, the cell of concern is Cell AF1, which could contain up to 200 words,

    My problem is I add words to the end of the listing I am unable to sort the into alphabetically.


    Everything else is AOK


    Regards


    Many Thanks to any answers.


    Peter


    Finder V2.07.xlsm

  • 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