| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Put in say, B1: =UPPER(A1)
Copy down Copy col B and paste special as Values to overwrite col A -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- "smithrdsr" wrote in message ... How to change data by column or comlete spreadsheet from lower case to upper case by column. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Retain PivotTable formatting after "Refresh Data" | Excel Discussion (Misc queries) | |||
| Formatting data | Excel Discussion (Misc queries) | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| Help with data not getting plotted | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Hybrid Mode
