Hi Everyone,
This thread is kind of an extension to the below thread
http://www.excelforum.com/excel-misc...16#post2802916
Russell Dawson I did try you suggestion but since my data had mixed delimiters it didn't work as expected so I used Marcol's Formula which I found was very useful and easier for me. Even Haseeb's would have worked if i had only <Space> OR <Space>
So thank you all for the support and guidance.
My current problem is that I have the data as per Marcol's Formula and now I need the keywords to be arranged in a Single Column, again the data is voluminous so can't do it manually
Thanks in advance for all the support
Regards,
Veejar
Bookmarks