| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i change all text case in a given worksheet at one time
I am attempting to change all the text in a 2,100 line item worksheet at the
same time with the results displaying in the orginal cell that previously had the data in it but was all upper case. I have tried the proper function and put a range in instead of the specifc text. The results dislayed in the cell the proper funtion was written in the last cell only from range I specificed. Is there a way to do the whole SS at a time |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to select a specific range based on the time value of user form input | New Users to Excel | |||
| How to convert Value to words?Eg.Rs.1000/- to Repees One thousand | Excel Discussion (Misc queries) | |||
| How do I change the case of text in more than one entry at a time | Excel Discussion (Misc queries) | |||
| Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
| Is there a formula to spell out a number in excel? | Excel Worksheet Functions | |||
Threaded Mode
