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