I have a list of combined material numbers and descriptions, separated by a blank character.
I want to extract the material number into a new column, primarily to sort it. The material number can be 2 to 6 characters before the blank character followed by the description i.e. 123 WWheel, 24351 JDodger.
How can I test for, and assign to a variable, the number of characters before the blank.
contact
us
