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

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.