| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capitalized Excel Data
I have data in an Excel spreadsheet that has both regular and fully
capitalized words. I would like to change everything to just regular words. How can I change capitalized spelled data to regular spelled data? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Capitalized Excel Data
Proper case
=PROPER(A1) Lower case =LOWER(A1) Upper case =UPPER(A1) If this post helps click Yes --------------- Jacob Skaria "paultheroach" wrote: I have data in an Excel spreadsheet that has both regular and fully capitalized words. I would like to change everything to just regular words. How can I change capitalized spelled data to regular spelled data? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving a line chart data point revises data table value in Excel ' | Charts and Charting in Excel | |||
| Count # of Capitalized Characters | Excel Discussion (Misc queries) | |||
| How to extract capitalized group in text string | Excel Worksheet Functions | |||
| CAPITALIZED ALL WORDS FROM WROKSHEET | Excel Discussion (Misc queries) | |||
| convert capitalized text to small text (with Capitalized names an | Excel Discussion (Misc queries) | |||
Linear Mode
