| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capitalise first word in a cell
Despite being selected in the Excel Options - autocorrect when I type a word
in my spreadsheet it wont start with a capital letter - any suggestions ?? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Capitalise first word in a cell
To convert existing entries to Proper case you can try
=PROPER(A1) If this post helps click Yes --------------- Jacob Skaria "alba146" wrote: Despite being selected in the Excel Options - autocorrect when I type a word in my spreadsheet it wont start with a capital letter - any suggestions ?? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Capitalise first word in a cell
Worth to take a look at the below link
http://www.mvps.org/dmcritchie/excel/proper.htm If this post helps click Yes --------------- Jacob Skaria "Jacob Skaria" wrote: To convert existing entries to Proper case you can try =PROPER(A1) If this post helps click Yes --------------- Jacob Skaria "alba146" wrote: Despite being selected in the Excel Options - autocorrect when I type a word in my spreadsheet it wont start with a capital letter - any suggestions ?? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| make cell equal a word if a data validation cell has a word in it | Excel Discussion (Misc queries) | |||
| CAPITALISE | Excel Discussion (Misc queries) | |||
| CAPITALISE GLOBALLY | Excel Discussion (Misc queries) | |||
| how can i capitalise text in an existing workbook | Excel Worksheet Functions | |||
| Trying to Capitalise on Input to Cells | Excel Worksheet Functions | |||
Linear Mode
