Common TEXT Funtions

#1: RIGHT – MID – LEFT

#2: LOWER – PROPER – UPPER

#3: LEN

#4: SUBSTITUTE – REPLACE

#5: FIND – SEARCH

#6: CONCAT – TEXTJOIN – &

#7: TEXT – VALUE

#8: DATEVALUE – TIMEVALUE

#9: TEXT – FIXED

#10: CHAR – CODE

#11: REPT