excel macro - need to extract information only after given string
I'm looking for a solution to extract some information from cells in a spreadsheet, and dump it into the adjacent column. Each cell contains a lot of junk, but always ends with the pattern "WX=" followed only by the information I would like to extract. The length of the information I would like is usually between 7-10 alphanumeric characters. Are there any functions that can already do this, or do I need an entirely unique script to acheive this?
Thanks for any help!
The function below will return the string after "WX=" from cell A1:
=RIGHT(A1, LEN(A1) - (FIND("WX=", A1) + 2))