Search results

Hi, Can any one hlp me MS-Access VBA code to seperate numbers and string from an alphanumeric string. Example: Source: 598790abcdef2T Output Required: 598790 Source: 5789065432abcdefghijklT Output Required: 5789065432 Please help, I am using MS Access 2007 Thanks Ram