Everyday Documents: Learn how to capitalise the first letter of a string using formulas within Microsoft Excel.

Topics covered include:
• Left() = Characters from left
• Right() = Characters from right
• Len() = Length
• Upper() = Uppercase
• & = Concatenate

Final equation:
=UPPER(LEFT(A1,1)) & RIGHT(A1,LEN(A1)1)

Website:
http://www.everydaydocuments.com

Software:
Microsoft Office 365

Music:
Vibe Tracks Foundation

#Excel #Formula #Capitalise