View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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