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