Replacing a character with a new row

asked 2016-02-01 14:48:36 +0200

Hi! I've been looking for a solution of my problem and no success so far, so I decided to ask you guys. I have a sheet that contains a dictionary and I need to reformat it a little. It looks like this:

|breakfast / break fast|desayuno|

As you can see there are two terms separated by slash in the left column and I need to replace the slash with a row insertion, so it'd look like this:

|breakfast|desayuno|
|break fast|                |

Or, even better:

|breakfast|desayuno|
|break fast|desayuno|

Is something like that even possible?

edit retag flag offensive close merge delete