Need a quick Excel Macro

Need a quick Excel Macro

Closed - This job posting has been filled and work has been completed.

Job Description

I have large excel sheet with over 1500 rows. I need the following:

- One of the cell has text in the following order:

http://xyz.com/detail/word1-word2- | - word3-word4-number1.htm

I want a macro that can process the above text and give me an output in the format below:

Word1 Word2 | Word3 Word4

It should be a cake walk for an experienced macro writer. PM me your expertise and confidence over this job and i will share the work excel.