yogi_Split Row By Row Set Of Courses Keyed In As A String With Comma Delimiter And Then Lookup Corrsponding Course Numbers From 'Course List'

Google Spreadsheet   Post  #2027

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-20-2016

post by: Michelle Roach:

https://productforums.google.com/forum/#!topic/docs/PnjVGtJvSEI;context-place=forum/docs

Remove a leading space that appeared after a split function

I have cells that will contain multiple parts for example French 1, French 2, French 3. I split it up but now would like to find a way for the space to be removed that is in front of French 2 and French 3.  I need the space gone because I'm also trying to do a vlookup in the following columns, using an array in another sheet. Here is a test spreadsheet:  https://docs.google.com/spreadsheets/d/174bTY332ZnlaOViWGVCD0q8kXTXeewVvZx-ycrxJxvM/edit?usp=sharing

Any help is appreciated!
--------------------------------------------------------------------------------