I would like to know how to extract/copy an embedded text (ie name) string .... and
place that copied info into another/adjacent column ..... all
while faced with the situation of a 'string' begins &/or ends with numbers, w w/o space, contains symbols, random lengths etc.
for instance chemicals can begin with letters, numbers, etc.. examples follow
all i want to do is extract the 'chemical name' from the text string, in order to Alphabetize/sort or my inventory. using FIND/SEARCH (left or right, #of charactors) doesnt work since front and back of the string can vary widely.
1,3-BUTADIENE, BUTANE FUEL, JT9458-3/TRICHLOROETHYLENE, TITANIUM OXIDE TI02, 14735 CARBON POWDER 30 MESH, etc...
a smaller inventory is not an issue but 1500+ is a bit to manually go through each item and copy/paste the name toa new column