Hi All,

I am using the REmid function to pick out 13 character strings that end with
l, h, c or u.

e.g. cell A1 contains....
FIELD C2 @CHANGE ("PRPPRUNWECEOl") SIGN NOZERO;

=REMID(A1,"\b\w{12}(l|h|c|u)\b") returns PRPPRUNWECEOl

However, i also have 13 character strings that contain "$" and "£" i.e.
PRPGU$NY$CILl.

The REMID function above does not return these strings, what do I need to
add to the search criteria in the formula to search for "$"?

Any help will be much appreciated.

Thanks

Bhupinder.