Function GetFirstWord(Source, WordBreak) GetFirstWord = Left(Source, InStr(WordBreak, Source) - 1) End Function
, how do I get the argument WordBreak value " " to be interpreted correctly in the InStr function. I just don't know enough about delimiters, punctuation, string formatting, etc. in VBA yet. Should be an easy one for you Experts.
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
27 Experts available now in Live!