Using OR within a FIND function

[someonehelppelase]

Hi,

I got some help here before to create a formula to grab the left information in a cell separated by a "/". Now, I have found data can also be separated by a '-' and need to incorporate this into the function as well.

Some examples of items that need to be split are:
Harrisburg-INTL
Dallas/Ft. Worth
Heathrow-LDN
Huntsville/Decatur

The current formula I have in place is:

=IFERROR(LEFT(DN7,FIND("/",DN7)-1),DN7)

This works perfect for cells using a /, but I was unable to find a way myself or online to incorporate the new construct.

Thanks for your help!

[AlKey]

Try this formula in DO7 and copy down

Please Login or Register  to view this content.

v	DN	DO
1
2
3
4
5
6
7	Harrisburg-INTL	Harrisburg
8	Dallas/Ft. Worth	Dallas
9	Heathrow-LDN	Heathrow
10	Huntsville/Decatur	Huntsville

[someonehelppelase]

Thanks! That worked. May I ask what the 50 is for? Just curious

[AlKey]

Thanks! That worked. May I ask what the 50 is for? Just curious

just an arbitrary number to accommodate the length of the string.

Thank you for the feedback

Please mark thread as "Solved" if your issue has been resolved. (Selecting Thread Tools-> Mark thread as Solved).