cut, delete, and paste: use formula or macro?

[kioken]

I need to cut some stuff from one column and paste them into the next one, and delete a character a long the way, though I'm not sure how to do it.

For example, there's this text in one column:

[TABLE="width: 393"]
<colgroup><col></colgroup><tbody>[TR]
[TD]X73-215_front__studio.jpg|X73-215_left__studio.jpg|X73-215_back__studio.jpg|X73-215_right__studio.jpg|X73-215_angle__studio.jpg
[/TD]
[/TR]
</tbody>[/TABLE]

I need to cut everything after the first pipe and paste it into the next column, then delete the pipe that's leftover. In the end, the first column should look like this:

X73-215_front__studio.jpg

And the second column should look like this:

X73-215_left__studio.jpg|X73-215_back__studio.jpg|X73-215_right__studio.jpg|X73-215_angle__studio.jpg

Is this something you do with a formula or with a macro?

 

[sheetspread]

Text to columns does this, also the formula in #6 here:

http://www.mrexcel.com/forum/excel-questions/916647-texto-column-formula.html