To make it title case, use Sub titleCase()Ĭell.Value = TitleCase(cell. Most keyboards have a key labeled Caps Lock on the left-hand side. You'll be converting names like 'Mackenzie' and 'Mack' to 'MacKenzie' and 'MacK'. 1 Check the Keyboard Caps Lock & Shift Keys on Your Mac. To make the first letter of each cell upper case you'd use cell.Value = UCase(Left(cell.Value, 1)) & Right(cell.Value, Len(cell.Value) - 1) 'This will make the first word in the cell upper case Re: Proper Case Mac, Mc Names In TextBox. Remember to take a back up of the file first! Sub uppercase()įor Each cell In Ĭell.Value = UCase(cell.Value) ' this will make the entire cell upper case I need to capitalize every cell in excel with first letter as capital?any easy way to accomplish it?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |