Help with =LEFT Formula

[bradjedis]

Greetings,

I have the following formula: =LEFT(A2,FIND("-",A2)-1). This works fine, except when I have a string such as 2345-1234-56789

I need to extract the first and second part of the string... 2345-1234. These could be more characters or fewer in each part between the dash, but the condition exists with having two dash's.

Thanks,

Brad

[HansV]

Try

=TRIM(LEFT(SUBSTITUTE(A2, "-", REPT(" ", 255), 2), 255))

[bradjedis]

Nice!


Thanks.

[snb]

=LEFT(A1;FIND("-";A1;FIND("-";A1)+1)-1)

[rory]

If you have a current version of 365:

=TEXTBEFORE(A2,"-",2)

[bradjedis]

Tried them all. ALl worked. Thanks!!