vksharma00001
Board Regular
- Joined
- Jun 9, 2014
- Messages
- 116
Hi Experts
I have a data like this:
<colgroup><col></colgroup><tbody>
</tbody>
I want a dynamic formula in excel so that i can extract 1st and 2nd word. Special character can be anything like this "-"," ","@",# etc.
I want Output like this:
<colgroup><col></colgroup><tbody>
</tbody>
I have a data like this:
Killians Self Retaining Nasal Speculum |
Suspension Laryngoscope |
Tonsillar Snare-Eves |
Micro Scissor Scissors |
<colgroup><col></colgroup><tbody>
</tbody>
I want a dynamic formula in excel so that i can extract 1st and 2nd word. Special character can be anything like this "-"," ","@",# etc.
I want Output like this:
Killians Self |
Suspension Laryngoscope |
Tonsillar Snare |
Micro Scissor |
<colgroup><col></colgroup><tbody>
</tbody>