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
 
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...
 
Back
Top