View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] jonafire@gmail.com is offline
external usenet poster
 
Posts: 3
Default Splitting Data in Cell

I have a database that lists addresses in the following format:
111 Maple Dr.

I want to split the street number from the Street name so that I can
sort on the street name only. Is this possible?