Combining Dates in a Table

Hey guys, let's say I have a table of dates. For instance:
12/6-12/17
1/4-2/14
4/5-5/6

What formula can I use that would output 12/6-5/6? I used the left() and right() formulas, but if I input different numbers (say, 5/16 instead of 5/6), then those formulas don't work because of the extra digit.

Thanks!

Hello & Welcome to the Board,

Are you looking for this...

=LEFT(A1,FIND("-",A1)-1)&MID(A3,FIND("-",A3),LEN(A3))

If not then please post a small sample workbook of what you have and what you expect.

Try in C7...

=LEFT(C3,FIND("-",C3)-1)&MID(C6,FIND("-",C6),LEN(C6))

One of the best ways to understand a formula is by using evaluate formula or the shortcut keys of Alt + T,U,F

From the Excel Help
Syntax
MID(text,start_num,num_chars)

Text is the text string containing the characters you want to extract.

Start_num is the position of the first character you want to extract in text. The first character in text has start_num 1, and so on.

Num_chars specifies the number of characters you want MID to return from text.

Look at C6
MID(C6,

Looks for the "-" to find the start number
FIND("-",C6),

How many characters
LEN(C6))

You're welcome.

If this satisfies your request, please do not forget to mark the thread as solved.