View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GatorGirl
 
Posts: n/a
Default How do I split a one cell which has a hard return?

The cell has an street address and then a hard return and on the second line
an apt #. Test to columns does not work because the street addresses vary in
length. Any ideas?