LEFT function
Hello,
What is the formula for obtaining the left-most characters in a phrase up to
the first blank space in that phrase? For example, for the phrase, '01
Summary', or '233 Summary', I only would only want to return '01' or '233',
respectively. I need to know how to read up to the first blank space and
then get the characters to the left of that blank space.
Thanks.
--
Pat Dools
|