HOW DO I SEPERATE INFO FROM ONE INTO TWO COLUMNS?

H

help needed

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.
 
P

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
 
Top