I spend a fair amount of time working with data strings in LibreOffice Calc. I have most often been successful in finding answers to questions by doing web searches, and have learned to use VLOOKUP, for example, to pull data from one sheet into another, how to truncate leading and trailing spaces in cells, how to do Find and Replace with Regex, etc.
I am writing this query to ask the community for suggestions for a book or a web site or sites where I can find more tips and tricks on using LibreOffice Calc with text strings? I am in essence looking for a source where I can find answers to the questions that I don’t yet know how to ask. And also for some Best Practices guidelines. Does this make sense?
Maybe someone working with Natural Language Processing with tokenization and lemmatization, and/or frequency studies has created cheat sheets and or Best Practices they would share?