If I have few lower case values in my column B how can I convert them to uppercase? I see that every one suggest to use =upper(B) but where and how should I use this function?
Thanks in advance.
If I have few lower case values in my column B how can I convert them to uppercase? I see that every one suggest to use =upper(B) but where and how should I use this function?
Thanks in advance.
In the next Column, or add a Column, enter the formula.
Copy down
Copy & PasteSpecial values over the original
Delete the new column
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks