View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stephanie Stephanie is offline
external usenet poster
 
Posts: 93
Default Replace ; with hard return

Hi. We are in the middle of a conversion and I'd like to make it easier.

We have a column that contains:

Chair; Desk; File
Chair; File
Desk; File

Items that are separated by a semi-colon.
Instead, I need these items separated by a hard carriage return within the
column:

Chair
Desk
File

Chair
File

File
Desk

Any suggestions are appreciated!