Is it possible to remove the numbers from the end of string variable using a simple VB function?
But it is clearly wrong, and even if it worked it would remove both 27's in the middle example below.
i.e I want strings:
"Number 23", "My 27 Isn't 27", "Test 44 5"
To be converted to:
"Number", "My 27 Isn't", "Test"
My full code is:
(where the bold line is where I need to trim the string)
If this isn't possible, could somebody please show me how I would loop backwards through a string removing any numbers until I reached a digit that wasn't a space or a number?