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
Download
0 formats
No download links available.
Capital first letter | Microsoft Excel Formula Tutorial | NatokHD