View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] Kathy.Chrysler@gmail.com is offline
external usenet poster
 
Posts: 1
Default Ascii iinput file - separate text from Numbers

I have an input file that I would like to get into separate cells. The
data is something like this:

George Bush123456-78902
Abe Lincoln9876-543210
May Lou Rettin76543-2109713

I don't care about separating the first and Last name. What I need is
to determine when the number begins. Any ideas?

Thanks!!