I am trying to somewhat use a "left" function but the number of characters I am needing to extract will vary. Here is what my data looks like. (Each line is one cell.)
#300 2007 Freightliner
#66471 2008 International
#4540 2009 International
I am needing to separate the unit numbers and...