How to capitalize the first letter in a cell in Excel

Written by  Monday, 26 June 2017 19:29

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))
182 Read Last modified on Thursday, 12 October 2017

Leave a comment

Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

1 comment