Wednesday, January 20, 2016

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   Jan-20-2016
post by: Michelle Roach:!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:

Any help is appreciated!