View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Himani Himani is offline
external usenet poster
 
Posts: 5
Default Extracting part of data

I have a list of phone numbers in one column and I need to separate
the bit before the space from the bit after it. e.g. 0 0 01444 831918
etc So I need to extract the 01444 before the space into column
Telephone area code and 831918 into telephone. Can someone please
advise? Thanks Himani