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
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Tennisgirl" wrote in message
...
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.