remove periods

K

kduffy

I have a field that contains information to extract.

i.e." billing change $12.16." I want to only extract 12.16
 
K

KARL DEWEY

If the data ALWAYS has a period on the end and a $ sign in it then use this --
Left(Mid([YourFieldName], InStr([YourFieldName], "$"), 254),
Len(Mid([YourFieldName], InStr([YourFieldName], "$"), 254))-1)
 
Top