Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
Yes, only the sixth to eleventh characters are required and these may be extracted with the MID function. MID is a string function that returns Text but a double unary operator should trigger Sheet...
Answer
#4: Post undeleted
by
Alexei
·
2021-05-26T18:11:32Z (almost 3 years ago)
#3: Post deleted
by
pnuts
·
2021-05-24T06:38:14Z (almost 3 years ago)
#2: Post edited
by
pnuts
·
2020-10-01T20:54:42Z (over 3 years ago)
- Yes, only the sixth to eleventh characters are required and these may be extracted with the [MID](https://support.google.com/docs/answer/3094129) function. MID is a string function that returns Text but a double unary operator should trigger Sheets' automatic date detection and display as `44105` when in default format:
- =--mid(A1,6,11)
- Yes, only the sixth to eleventh characters are required and these may be extracted with the [MID](https://support.google.com/docs/answer/3094129) function. MID is a string function that returns Text but a double unary operator should trigger Sheets' automatic date detection and display as `44105` when in default format:
- =--mid(A1,6,11)
- The same formula works in Excel and LibreOffice Calc, given suitable delimiters.
#1: Initial revision
by
pnuts
·
2020-10-01T18:50:51Z (over 3 years ago)
Yes, only the sixth to eleventh characters are required and these may be extracted with the [MID](https://support.google.com/docs/answer/3094129) function. MID is a string function that returns Text but a double unary operator should trigger Sheets' automatic date detection and display as `44105` when in default format:
=--mid(A1,6,11)