Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

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))))



Wait... 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?


I 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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: