Results 1 to 6 of 6

display the dates in two cells in a single cell separated by hyphen

Threaded View

  1. #1
    Registered User
    Join Date
    12-11-2010
    Location
    bangalore, India
    MS-Off Ver
    Excel 2003
    Posts
    6

    display the dates in two cells in a single cell separated by hyphen

    hi,

    i need the dates in 2 different cells to be combined in one cell separated by hyphen and display the same.

    i tried in a3 "=a1 & a2" it is giving some numbers
    example:
    in cell a1 03-mar
    in cell a2 04-mar
    now in cell a3 i need 03-mar - 04 mar

    thanks in advance
    Girish
    Last edited by girish749; 02-22-2011 at 06:29 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1