View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ChristineR
 
Posts: n/a
Default How do I unwrap text to columns?

I have a spreadsheet where the addresses have been saved as wrapped text in
one column. I want to spilt the addresses into columns as Address1, Address2
etc but I can't enter the wrap character (which I think is ALT+ENTER) as a
delimiter in the Text to Columns wizard.

I have also tried search and replace but again Excel will not recognise
ALT+ENTER as a delimiter

Any ideas much appreciated! Thanks