If you have text in a cell with the words separated by spaces, you can use
the Data TextToColumns feature with "space" as a delimiter to split each
word out into it's own column..........then you can use the CONCATENATE
function to put them back together in any order you wish..........

hth
Vaya con Dios,
Chuck, CABGx3



"nastech" wrote:

Hi, is there a formula or script for copying a portion of a column / selected
range of words/text, to a single cell. Looking for separation by spaces, and
option to have sorted as listed, or alphabetically. Thanks.