Combing 2 cells with date info into 1 cell

[trolle]

Example attached.

I have 2 columns with date info

I want to combine these 2 columns into a single column, e.g. A1&" to "&B1

Basically, I want to create a date range in the 3rd column to use it as the axis data in a graph.

[AliGW]

Like this:

=TEXT(B3,"dd-mmm-yy")&" to "&TEXT(C3,"dd-mmm-yy")

HOWEVER, Excel cannot read this as two dates, only as text. This is true whenever you have more than a simple date in a cell.

[63falcondude]

Try this:

=TEXT(B3,"dd-mmm-yy")&" to "&TEXT(C3,"dd-mmm-yy")

Edit: Beat to it!

[Glenn Kennedy]

You can use:

=TEXT(B3,"dd-mmm-yy")&" to "&TEXT(C3,"dd-mmm-yy")

but depending on your regional settings you may need ; instead of ,

Addtionally day month and year may not be d m and y in danish Excel....

[trolle]

Thanks AliGW...worked liked a charm.