Thread: LEFT function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pat Dools
 
Posts: n/a
Default 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