Lets see how to change the case of the text
In Excel - formula is
Upper(A1) this would convert the text in A1 cell to Uppercase
Lower(A1) this would convert the text in A1 cell to Lowercase
If the same has to be implemented in Excel macro the coding goes like this
Varnamet = UCase(the cell or value)
No comments:
Post a Comment