Hi Kyle and thanks for supplying a VBA alternative for the OP.

However, it returns #VALUE! error for the last sample in the original post because of spaces around the X.... I used the SUBSITITUTE() function to deal with it.. can you adjust your code accordingly for the OP (and me too )