4 ms·
Related? I was copy'n'pasting a few chars from one column from to another in gsheets. Gsheets intuited that I wanted to do this multiple times and offered this
by emmelaich 3y ago
Related? I was copy'n'pasting a few chars from one column from to another in gsheets.
Gsheets intuited that I wanted to do this multiple times and offered this formula:
> =RIGHT(A7,LEN(A7) - (FIND(CHAR(160),SUBSTITUTE(A7," ",CHAR(160),2))))
- sebastiennight 3y agoWait... this... outputs the right-hand part of a cell in column A that follows the second space character in the string? How is that related to anything? Was it, at least, the correct formula for your need?
- emmelaich 3y agoI presume it was the AI/ML part watching me doing the manual stuff and automating it, which is cool. Yes it was correct. It gave me 43h0m from "08 Jan 43h0m". Obviously over a column. I was able to adjust that to give me time durations.