View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gene Shackman Gene Shackman is offline
external usenet poster
 
Posts: 1
Default excel, seperating numbers and text, macro

I have a file with lines like these

nominally Roman Catholic 92% (less than 20% practicing)
Armenian Apostolic 94.7%
Roman Catholic 80.8%
Eastern Orthodox 80%
Roman Catholic 75%
Buddhist 9.3%
Baptist 42%

my file has 250 lines. I want to separate the data from the text. Is there
any way to do this other than manually going through each line and separating
the data? I considered a macro but each line is different. In some cases
the number has 2 digits and no decimals but in other cases it has decimals.

thanks