Page 1 of 2 12 LastLast
Results 1 to 10 of 16
  1. #1
    Members
    Join Date
    Jan 2004
    Posts
    1,971

    Excel help with conversion of text string to date format?


    0 Not allowed!
    I have a training database that rather unhelpfully exports to Excel the date of training as a string in a single cell " Monday 2 November 2017 ". I'm not interested in the day of the week but just want to convert to date format 02/11/2017 thereby allowing sorting or use in pivot table.

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •