563051ad_oddments__tion_of_the_Worksheet_Function
[Name] TextBeforeNum [Parameters required] NumPos - the position of the start of the numeric value within the string. WordNum - the number of words you want to return. MyString - the string value from which you wish to extract the information. An '#Error' string is returned if the instruction cannot be completed. [Date] 02 Dec 2008
Returns a specified number of whole words before the position of a numeric value within a string.
oddments
Description of the Worksheet Function