View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Michael
 
Posts: n/a
Default Function, dont know what its called

I have the following example:
A
1 13 main st
2 37892 Oak st
3 8237 54th St

I want to seperat the address from the street name in a seperate colum to
end up with the following:

A B
1 13 main st
2 7892 Oak st
3 48237 54th St

Any help would be greatly appreciated.

michael