Thread: separating text
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
dpdpdp dpdpdp is offline
external usenet poster
 
Posts: 2
Default separating text

I received a name and address file that combines all of the data into once
column. Unfortunately I need to separate out into 6 columns the folowing
(name, add line1, add line2, city, state, zip). Example follows.

Jane Smith Inc Attn:Accounts Payable 207 Main Street XTown, NJ 07912