Hi All
I hope I'm explaining myself properly. I got help with you guys to find a word in cell D9 and transferred it over to E9 using "-" which worked great. =RIGHT(D9,LEN(D9)-FIND("-",D9,1)-12). Example John Smith - Hockey. The formula was able to pick up "Hockey" which was great. Problem I having is if I use John Smith - Jones - Hockey. It picks up the first "-" and enter "Jones". I would like to find a formula that picks up the last "-" in a cell even if there are more than 1 "-". I hope I'm note asking to much.
Thank You