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!

Answers


The function below will return the string after "WX=" from cell A1:

=RIGHT(A1, LEN(A1) - (FIND("WX=", A1) + 2))

Need Your Help

referring to an array outside of a loop

arrays loops unix reference echo

So I have something that looks like this:

Modifying a function used as a column default in SQL Server

sql tsql function constraints

We're having an issue with a poorly coded SQL function(which works fine in live, but not in our test environment). This function is used to provide a default value in many tables, trying to ALTER the