Thanks SAM, for prompt response...currently i using the same option to convert date and text to columns option for time...
Due to data size...it is taking more time. Regards Chethan Kumar BN On Thu, Oct 6, 2011 at 10:43 AM, Sam Mathai Chacko <samde...@gmail.com>wrote: > =DATEVALUE(LEFT(A3,2)&"/"&MID(A3,FIND(" ",A3)+1,3)&"/"&RIGHT(A3,4)) > > Regards, > > Sam Mathai Chacko (GL) > > > On Thu, Oct 6, 2011 at 10:20 AM, B.N.Chethan kumar < > chetankumar1...@gmail.com> wrote: > >> Hi All, >> >> I have attached file where i get some data in text format. I need convert >> to date and time format. >> >> Currently using text to coloumn method which is manually pocess. As sheet >> count is high in a workbook, these is very painful work to do in month end. >> >> Kindly request your help to very painful work. >> >> -- >> Regards >> B.N Chetan kumar >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Sam Mathai Chacko > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- B.N Chetan kumar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel