Last active
December 30, 2015 20:59
-
-
Save AnneTheAgile/7884521 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
The usual easy way of LibreOffice aka Excel translating a column by editing its contents. | |
Formulae; | |
=SUBSTITUTE(D2,"HDR ","",1) # Necessary | |
=FIND("HDR ",D1) # FYI | |
EX.: | |
# Format row; Label row, Data row | |
# Used 3 tabs here on gist to delimit | |
[out-as-str] [out-as-calc] [other-field] [input] | |
CategoryCalc CategoryCalc Concept Category0 | |
Philosophy/Epistemology Philosophy/Epistemology “A Priori” HDR Philosophy/Epistemology | |
REFS | |
[1] Libre aka Open office | |
https://help.libreoffice.org/Calc/Text_Functions#SUBSTITUTE | |
[2] Excel Finance data hackers' list of some fundamental Excel commands | |
http://www.modeloff.com/wp-content/uploads/2013/02/Excel-Knowledge-Test.pdf | |
Microsoft Word - Excel Knowledge Test.docx - Excel-Knowledge-Test.pdf | |
ModelOff 2012 Questions and Answers |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Hmm, rats, only this makes links live;
WISH there were an MD format.
REFS
[1] Libre aka Open office
https://help.libreoffice.org/Calc/Text_Functions#SUBSTITUTE
[2] Excel Finance data hackers' list of some fundamental Excel commands
http://www.modeloff.com/wp-content/uploads/2013/02/Excel-Knowledge-Test.pdf
Microsoft Word - Excel Knowledge Test.docx - Excel-Knowledge-Test.pdf
ModelOff 2012 Questions and Answers