=A2&" "&B2&" "&TEXT(C2,"HH:MM AM/PM")
Use the above formula On Thu, Oct 30, 2008 at 11:15 AM, vinu <[EMAIL PROTECTED]> wrote: > > Hi this works well. > How to concotenat the time formate for eg: > MS Exce 12:15 AM how to do this.. > > Regrds, > vinu. > > On Oct 29, 9:18 am, "Bhavish Poddar" <[EMAIL PROTECTED]> wrote: > > Hi use this function : =A1&" "&B1&" "&TEXT(C1,"dd-mmm-yy") > > where A1 = MS > > B1 = Excel > > C1 = 29-0ct-08 > > > > On Fri, Oct 24, 2008 at 11:31 AM, H Upadhyay <[EMAIL PROTECTED] > >wrote: > > > > > > > > > Pls chk attached file > > > > > Regards > > > Harish Upadhyay > > > > > On 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > > > >> Hi All, > > > > >> I have an issue while using concatenate formula, Can any one of you > help > > >> me out with this: > > > > >> Query: > > > > >> Column A : MS > > >> Column B : Excel > > >> Column C : 24- Oct-08 ( formated as d-mmm-yy). > > > > >> When I use concatenate i get a result as : MS Excel 39745 > > > > >> After formatting the cell too d-mmm-yy, I get the same result instead > of > > >> MS Excel 24-Oct-08. > > > > >> Please advice me if there is any other way out to get the result as > > >> desired. > > > > >> Thanks in Advance > > > > >> Cheers > > >> Shyam > > > > -- > > Thanks and Regards, > > > > Bhavish Kumar Poddar > > Sr. Executive - Business and Process Analytics > > > > V5 Global Services Pvt. Ltd > > 203-206, 2nd Floor, Skipper House, > > 62-63, Nehru Place, New Delhi-110019 > > T: +91 11 4651 5500 > > D: +91 11 6662 0396 > > F: +91 11 2623 2329 > > M: +91 9871809605www.v5global.com| [EMAIL PROTECTED] | skype: > bhavishp > > > > --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
