Is this text string in an Excel Cell? or is it a text string from another source?
More importantly, if it is in a cell, and you change the cell format to "short date" does it change? Are you wanting a cell formula, or a macro? What do you want to do with the separate values once you've extracted them? Paul ----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- ________________________________ From: Muhammad Arslan <arslanacca...@gmail.com> To: excel-macros@googlegroups.com Sent: Tue, October 18, 2011 5:31:33 AM Subject: $$Excel-Macros$$ Extract from date and time Dear Experts I need to disjoint date and time form a text. Help me out how to tackle in excel using formuale. Text is following 4/11/2011 08:39:20 PM Help me out hoping for your prompt relpy. Kind Regards Muhammad Arslan -- ---------------------------------------------------------------------------------- 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 -- ---------------------------------------------------------------------------------- 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