AsgiE
New Member
- Joined
- May 26, 2005
- Messages
- 44
I need help in getting a formula that will be able to extract a specific word from a string within a cell ie:
I want to extract "Recoverable" from a string in a cell and the word Recoverable can be at any location within that cell. I cannot use Mid as I dont know the starting point.
I could use the letter R as the search point for Match to compute the starting point for the Mid formula but need help in putting it together.
Appreciate the help.
Thanks
Asgi
I want to extract "Recoverable" from a string in a cell and the word Recoverable can be at any location within that cell. I cannot use Mid as I dont know the starting point.
I could use the letter R as the search point for Match to compute the starting point for the Mid formula but need help in putting it together.
Appreciate the help.
Thanks
Asgi