| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
STRING functions
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 ???? :( -- anar_baku ------------------------------------------------------------------------ anar_baku's Profile: http://www.excelforum.com/member.php...o&userid=18259 View this thread: http://www.excelforum.com/showthread...hreadid=483147 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| String Extraction... | Excel Worksheet Functions | |||
| Auto convert an alphanumeric string (CIS9638S) to numbers only? | Excel Worksheet Functions | |||
| Improvements for text finding functions | Excel Discussion (Misc queries) | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| How do I use 3 cells to create the string for a lookup function? | Excel Worksheet Functions | |||
Threaded Mode
