| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Assuming your original IDs are in column 1. Use a helper column eg
=UPPER(A1), then copy down. You can then copy and Paste SpecialValues to overwrite the original data. -- Ian -- "Dinesh" wrote in message ... Is there a way that we can convert lower case charecters to upper case in MS Excel cells? I have more than 150 User ID's written down in Excel using both Upper case and Lower case. But now I need to convert them in to upper case. Is there an option for that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
| How to convert entire excel document from lower to upper case | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
Hybrid Mode
