join text from multiple cells to one cell

**stoey** · 04-27-2009, 05:56 PM

hi,

i know this is easy but i don't have an idea how to do it.

uhmm..I have dates written on column A1:A7 like

29-Mar-09
30-Mar-09
31-Mar-09
1-Apr-09
2-Apr-09
3-Apr-09
4-Apr-09

what I would like to do is how can I combine 29-Mar-09 and 4-Apr-09 into one cell...I would like the output to be placed in cell A8 appear as "29-Mar-09 to 4-Apr-09". I appreciate any help...thanks

regards,

stoey

**VBA Noob** · 04-27-2009, 06:07 PM

Does this help

Please Login or Register  to view this content.

VBA Noob

**stoey** · 04-27-2009, 06:10 PM

hi VBA Noob,

I appreciate your quick response...i apologize for not being clear...i forgot to mention, can this be done by placing the code on the formula bar of excel?

regards,

stoey

**VBA Noob** · 04-27-2009, 06:17 PM

can this be done by placing the code on the formula bar of excel?

Do you mean you want a formula and not code?

If so why post to Programming?

Try

=TEXT(A1,"dd-mm-yy")&" to "&TEXT(A7,"dd-mm-yy")

VBA Noob

**stoey** · 04-27-2009, 06:28 PM

hi,

Please Login or Register  to view this content.

this code works! thanks a lot! oops sorry if I post on the wrong board...can you please tell me how to relocate this post so i may transfer it on the proper board. thanks again!

regards,

stoey