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.
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.
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
=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 arehappy 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
Was typing the same things, you guys beat me too it![]()
Thanks a lot guys.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks