Hi all,

Does the function to sort text within a cell exist or a work around. Currently my idea is to break them into multiple cells, transpose, sort transpose again, and recombine. I think this is possible but will take much time and resources as I am currently working with at least 30 thousand line. Would appreciate any help on this... even a VBA solution would be great if that is the only possible way!

Example cell: (within a cell) Orange Apple Banana Pineapple Grape
Desired result: Apple Banana Grape Orange Pineapple

background of problem: I need to compare data between two worksheet. However, no common data between the two data set except name is available. The issue is the name format is different (last, middle, first, etc) and inconsistent (some has . and between 2 to 5 names). My solution is to sort the name column in both worksheet to get a common denominator to work with.


Thanks in advance! Hope every one stays safe in this pandemic times. Cheers