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.