HOW DO I SEPERATE INFO FROM ONE INTO TWO COLUMNS?
 

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.

HOW DO I SEPERATE INFO FROM ONE INTO TWO COLUMNS?
 

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

HOW DO I SEPERATE INFO FROM ONE INTO TWO COLUMNS?
 

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.