125 reputation
115
bio website
location
age
visits member for 4 years, 4 months
seen Dec 1 '13 at 14:29

Jul
15
comment Excel - Delete specific word in each row?
Your last solution is exactly what I need. Thanks again!
Jul
13
comment Excel - Delete specific word in each row?
Wow, that's great. I was wondering how to deal with instances where there is only one title (e.g., only "Mrs."). My thought was to temporarily substitute " and " with "-and-", so that all titles are treated as a single word; then keep the first and last words; and finally, switch "-and-" back to " and ". Presumably there is a way to incorporate this into the formula, but I don't even know where to start. Thanks!
Jul
13
awarded  Scholar
Jul
13
comment Excel - Delete specific word in each row?
Thanks, worked great!
Jul
13
awarded  Student
Jul
13
asked Excel - Delete specific word in each row?