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!
|