Got something to say or just want fewer pesky ads? Join us... 😊
Search results
-
Excel help with conversion of text string to date format?
Please power query,available as an add-in on earlier versions too. I barely write a formula. Sent from my LG-K520 using Tapatalk- clapham_gull
- Post #15
- Forum: The Big Board
-
Excel help with conversion of text string to date format?
Something like... Subsitute( a1, left(a1, seach(" ", a1)-1), "") Sent from my LG-K520 using Tapatalk- clapham_gull
- Post #8
- Forum: The Big Board
-
Excel help with conversion of text string to date format?
Find the first space.. And remove the day. Then convert to date. Sent from my LG-K520 using Tapatalk- clapham_gull
- Post #7
- Forum: The Big Board
-
Excel help with conversion of text string to date format?
I'm a great advocate of the Power Query functionality. You just don't have to deal with rubbish like this any more. Sent from my LG-K520 using Tapatalk- clapham_gull
- Post #6
- Forum: The Big Board