Which function do I need to use to truncate value
Acct as output value
Acct = Banking 111111 USD
I don't need Last three digits they need to be truncated
Assuming you mean the last 3 characters and not just digits:
new_acct = left(acct, len(acct) - 3)
Thanks Mehlerr Works fine
U could also use mid.
Winds of Change
a = "Banking 111111 USD"
b = Replace(a, "USD", "")