HOW DO I SEPERATE INFO FROM ONE INTO TWO COLUMNS?

[Guest]

I need to split sizes into length and width.
i have the sizes in format 10x10 and want to split them into 2 colums and
lose the x.
to complicate it more some sizes go into decimal points.

any ideas.

 

[Dave Peterson]

Select the column
data|text to columns
delimited
By other (and type X)

 

[Pete_UK]

If you always have an "x" separating the two numbers with no spaces,
then the following formulae will split the first and second numbers,
assuming your data is in cell A1:

first number: =VALUE(LEFT(A1,FIND("x",A1)-1))

second number: =VALUE(RIGHT(A1,LEN(A1)-FIND("x",A1)))

FIND is case sensitive - you might prefer to use SEARCH instead.

Hope this helps.

Pete