Can someone please help me with a formula to extract a word from a cell starting from the right moving left until blank. I want to put this information into a separate cell.
Here is sample of the data:
Univ. Connecticut Med School Farmington
266 Coldbrook Road Glastonbury
100 Retreat Avenue Hartford
195 S. Main Street Middleton
87 Grandview Avenue Waterbury
87 Grandview Avenue Waterbury
THANKS so much for any assistance
Karen
Here is sample of the data:
Univ. Connecticut Med School Farmington
266 Coldbrook Road Glastonbury
100 Retreat Avenue Hartford
195 S. Main Street Middleton
87 Grandview Avenue Waterbury
87 Grandview Avenue Waterbury
THANKS so much for any assistance
Karen