delet the last two digits in a string of serial # in a column
Posted by Allan on February 13, 2001 6:12 AM
I have a column with hundreds of rows of serial # like this: 37A800101
I want to delete the last two digits of each serial #.I have tried to use the wildcard"*" and "?" in replace function in different ways, like replace: 37A?????? with 37A????. But none of them work. The function replace all cells with 37A???? in stead of automatically pick up the next 4 digits accordingly.
Please help me with this matter ASAP .
thanks in advance.