Back to Browse

Capital first letter | Microsoft Excel Formula Tutorial

445 views
Dec 10, 2021
2:49

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