This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a string in a cell that has the format AB1234(Name). I would like to remove everthing past the 4. The result would be each cell under the column LOT_NUMBER would be AB1234. I have tried the word function ; for each row(word(1,:LOT_NUMBER,"(")); This did not work. Can you please give me a recommendation.