• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. N

    Removing noise information and converting to date format

    Dear Narayan and oldchippy - thanks very much for the quick feedback. Oldchippy - that was brilliant and it worked! Thanks for the welcome to the forum - I'd been reading through for a while, but this is my first post. This was very helpful and I hope to continue using it.
  2. N

    Removing noise information and converting to date format

    Dear experts - I have a file with date and other gibberish added in each line as below. I need a formula that can: 1)Remove all characters after the date (this could be 18 - 20 characters) 2)Convert the remaining date piece into readable date format 2012-1-10.22.10. 38. 154000000...
Back
Top