Remove Character from field

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

Guest

I need to remove a character imbetted in the middle of a field (example:
remove the "." from 33.22620). The character is always in the same position,
in this case the third character from the left. Thanks for you help

DT
 
Why dont you just multiply the number by 100000 and you will get
3322620.
 
Check out the Replace function:

Debug.Print Replace("33.22620", ".", "")

Just make sure that it's a text field and not a number.
 
Perfect...thank you!

Jerry Whittle said:
Check out the Replace function:

Debug.Print Replace("33.22620", ".", "")

Just make sure that it's a text field and not a number.
Click to expand...
 
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

Extracting data from field 3
Querying for Extended ASCII Characters 1
How do I validate a field has 5 characters (alphanumeric)? 4
Find xth occurrence of a specifiecd character in a string 3
Please help with access expression 1
Remove last character 1
Quotation Mark Question 3
Delete Specific Characters From Text 1

Back
Top