Monday, 26 June 2017 19:29

How to capitalize the first letter in a cell in Excel

Written by
Rate this item
(1 Vote)

That was how to capitalize just the first letter of each word in a cell using the Microsoft Excel very easy (change A1 to you num.cell)

// For example: A1 = katy
=CONCATENATE(UPPER(LEFT(A1,1)),RIGHT(A1,LEN(A1)-1))
Read 356 times Last modified on Thursday, 12 October 2017 14:11
Admin

Live and Be Free