I wonder if anyone can help me (again!) I have an excel sheet which has 500+
rows of data which has come from a database - one of the colums is a size
column and has data like the bit below:

3.803 X 3.327 X 0.391
6.519 X 6.053 X 0.27
003.745X 002.080X 009.850
003.745X 002.080X 009.850
002.790X 001.580X 006.400
002.860X 001.580X 009.470
3.05 / 2.075 / 2.05
2.68 X 2.0 X 9.53
003.660X 002.230X 004.640

I would like to split this into 3 seperate colunms and thought I had nothing
better to do but use the text to colums comand - however there are so many
different formats that even with the column sorted it is taking me a long
time to sort out!

Is there an easier way to do this??

Many thanks

Wendy