+ Reply to Thread
Results 1 to 5 of 5

Combine more than 2 cells in 1 cell

  1. #1
    Registered User
    Join Date
    01-27-2014
    Location
    Chittagong, Bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    5

    Question Combine more than 2 cells in 1 cell

    A1=SHAHIN
    B1=1/1/2014 12:01:00 AM
    C1=1/2/2014 9:30:00 AM

    Now I want combine all three cells data in one cell as like below:

    SHAHIN FROM 1/1/2014 12:01:00 AM TO 1/2/2014 9:30:00 AM


    I am new in this forum. Plz help someone.

    Regards;

    Shahin.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Combine more than 2 cells in 1 cell

    If time is text =A1&" FROM "&B1&" TO "&C1

    If not replace B1 in the above as TEXT(B1,"m/d/yyy hh:mm:ss AM/PM")
    Same for C1

  3. #3
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Combine more than 2 cells in 1 cell

    =A1&" FROM "&TEXT(B1,"dd-mm-yyyy hh:mm:ss AM/PM") &" TO " &TEXT(C1,"dd-mm-yyyy hh:mm:ss AM/PM")
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  4. #4
    Registered User
    Join Date
    09-25-2006
    Location
    North West, UK
    MS-Off Ver
    2010
    Posts
    73

    Re: Combine more than 2 cells in 1 cell

    Was typing the same things, you guys beat me too it

  5. #5
    Registered User
    Join Date
    01-27-2014
    Location
    Chittagong, Bangladesh
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Combine more than 2 cells in 1 cell

    Thanks a lot guys.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Combine multiple cells text into one cell, skip blank cells.
    By T15K in forum Excel General
    Replies: 6
    Last Post: 12-05-2014, 09:49 PM
  2. combine the contents of several cells into one cell.
    By nadeem.ansari1980 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-29-2013, 08:39 AM
  3. [SOLVED] Combine two cells into one cell
    By quillmaster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-31-2013, 04:27 PM
  4. combine info in several cells into one cell
    By double a enterprises in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-25-2010, 10:34 AM
  5. Combine cells to one cell
    By mpquin in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-03-2007, 04:02 PM

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