STRING functions

  • Thread starter Thread starter anar_baku
  • Start date Start date
A

anar_baku

I have the following problem, please help me out:

I have text strings in the following format:

xxxxxxxxx-yyyyyyyyyyyy
xxx-yyyyyyyyyyy

I want to extract the 1st parts from the above strings (i.e. xxxxxx
part). Using the simple LEFT function is out of question as the string
length varies. The only thing that is consistent among these strings is
that the 1st Parts and 2nd Parts are seperated by a "-". Is there a way
to tell excel to extract everything before the "-"? I imagine FIND
fucntion will be used to find the "-" in the string, but what then ????
:(
 
Hey Max,

You could've used Find() and made the OP feel good, in that (s)he at least
picked the right function.<bg>
 
You're welcome !

As RD said <g>, here we could have used FIND instead of SEARCH

FIND is case sensitive while SEARCH is not,
but it doesn't matter here since we're looking for the "-", not alphas
 
Back
Top