Originally Posted by
elbmag
I have a spreadsheet that prompts the user to enter an account number. The account number is in the format of C0001234. I am using a function to return the last 4 characters which are then passed to a query. I'm using the "right" function to get these last 4 characters. This works fine except when there are leading zeros in the result. For example the account number may be C0000C60. The function returns "0C60" and I need it to only return "C60". Is there any way to accomplish this? If the original account number was C0000020. I would want it to just return "20".
Bookmarks