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 ????
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 ????