View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
barrie barrie is offline
external usenet poster
 
Posts: 7
Default Partitioning Excel cell contents into separate cells

I have acquired a large spreadsheet with a column of cells each of whose
contents are like [1.234 6.712 5.436]
Numbers like these, contained in square brackets, are from another
application. How do I extract each number and place them in cells in
adjoining columns, to get:
column 1 column 2 column 3
1.234 6.712 5.436
?