(most useful in red / As mais utilizadas encontram-se a vermelho)

1. Extract numbers into separate columns

=SPLIT(lower(A3),"qwertyuiopasdfghjklzxcvbnm`-=[]\;',./!@#$%^&*()")

2. Extract text into separate columns

=SPLIT(A3,"1234567890`-=[]\;',./!@#$%^&*()")

3. Extract N characters starting at the Nth Character

=MID(A3,3,1)

4. Extract remaining characters starting at Nth character

=MID(A3,11,LEN(A3))

5. Extract numbers from a string

=VALUE(REGEXREPLACE(A3,"[^[:digit:]]", ""))

6. Extract text from a string

=REGEXREPLACE(A3,"[^[:alpha:]]", "")

7. Remove punctuation

=REGEXREPLACE(A3,"[[:punct:]]", "")

8. Extract characters before a suffix

=REGEXEXTRACT(A3,"([[:print:]]+)Code")

=LEFT(A3, SEARCH("Code",A3)-1)

9. Extract first word / name

=REGEXEXTRACT(A3,"[^[:space:]]+")

=LEFT(A3,FIND(" ",A3)-1)

10. Extract first character

=REGEXEXTRACT(A3,"[^[:space:]]")

11. Extract last name

=RIGHT(A3,LEN(A3)-FIND("*",SUBSTITUTE(A3," ","*",LEN(A3)-LEN(SUBSTITUTE(A3," ","")))))

12. Extract Nth word

=INDEX(SPLIT(A3, " "),1)

13. Extract N characters from the left / right

=LEFT(A3,2)