Look at datatext to columns, delimted and space as delimiter


Regards,

Peo Sjoblom

"Newbie1092" wrote:

I have a template work sheet that contains several cells that hold multiple
pieces of data. One of the things that I have to do with each cell is sort
the data in the cell into alphabetical order. I understand I have to first
break the data out into individual cells and then sort thos cells. My issue
is the template needs to be set up so that the data can be pasted from a .csv
file so Iu do not have the ability to use the "text to columns" feature. I
need the formula to split this data already set up and ready to go. An
example of the data is as follows:

CII CTI DDI DE TEUP BIU2 XWUU AAU

There can be as few is 1 data item or as many as 100 in each cell. Then
going down the column there can be as few as 1 cells in the column or as many
as 1000 cells. Each cell should be treated as an individual issue and there
is plenty of room to the right for breaking the cell out.

Does anyone have any suggestions??