MUST LEARN! Increase Efficiency! Excel Text Formatting: Easy to Advance, Step by Step
Text Formatting in Excel includes use of PROPER, UPPER, LOWER, TRIM, CONCATENATE Excel function and Excel formula, Superscript, Subscript, separate the words, header, footer and page number settings.
Feel free to jump to the topics below:
Complete Practical Tutorial
#1 PROPER 0:40
PROPER: Return the value with the first letter always capitalised and the rest of the string in lower case
#2 UPPER, LOWER, TRIM 1:36, 2:23, 3:05
UPPER: Capitalised all the letters
LOWER: Lower case all the letters
TRIM: Eliminate unnecessary spaces
#3 CONCATENATE 4:17
CONCATENATE: To link the string together
#4 Superscript, Subscript 6:28
#5 Separate the words 7:10
#6 Header, Footer, Page number 9:38
3 Minutes Tutorial provides Educational Video, ranging from high school tutorial to practical computer skills.
#Excel
#TextFormat
#MustLearn
Facebook Page:
/ flameshadow2015