remove periods

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field that contains information to extract.

i.e." billing change $12.16." I want to only extract 12.16
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

BROWSE LIST 1
records at max values 1
IF/SUMIF function 2
Do these PSU readings look OK? 2
Left join query problem 6
finding only cells with a numeric value 3
Extracting Data based on time 3
Extract specific information from the body of outlook mail to an Excel File using VBA 0

Back
Top