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.

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





help needed wrote:

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

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

help needed wrote:
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.