truncate part of import data

J

Jill0817

I'm importing a field that is delimited and has some ending alphanumeric
characters (usually 04 or 05 at the end of the cell). However they seemed to
be "spaced" and not "tabbed". How do I remove these alphanums from all of
the cells?
 
Top