I am comparing to columns of data from MS Project using Excel. In one column are the resource names for the project tasks. In addition to the names are the designations for % utilized. So the column's data will look like this:
John Jones[15%],Mary Smith, Fred Arguello[240%].

I want to compare this column with another resource names column which will never have utilization values - only the names.

In order to do that I need to "mask" the non alpha characters out of the first string.

Any thoughts on how this can be accomplished?

-denise