Seperating Data within cells

[Guest]

I have a huge data file with colums contain data that need to be seperated
The data was entered into the cells 2#5#8# etc. (numbers can range from one
to 38). I need to get all the 2's into a colum all the . 3's, 4's, 5's...
and they all need to line up. I am trying to figure out how to do this since
one cell may start with one number and then next cell a different one?
Please help! I hope this makes sense.

 

[Max]

Perhaps try using Data > Text to Columns with delimiter: # ?

Select the column

Click Data > Text to Columns
Check "Delimited" > Next

In Step2, enter in the "Other:" box: #

Click Finish

 

[Gordon]

I have a huge data file with colums contain data that need to be seperated
The data was entered into the cells 2#5#8# etc. (numbers can range from one
to 38). I need to get all the 2's into a colum all the . 3's, 4's, 5's...
and they all need to line up. I am trying to figure out how to do this since
one cell may start with one number and then next cell a different one?
Please help! I hope this makes sense.

Data-Text to Columns and use # as the delimiter.....