Excel - Separate Dates from Text: Episode 1520

You're an absolute beast, thank you

Great follow-up Bill. Thanks

Bill this is great. The way I solved this is to select all of column A and CNTL+H (replace) and replace the "Pay as of "(with a space after the f in of) with blank.

thanks much for answering my question :) ...