Past Tip of the Day
Ruth asks: I need to convert an Excel file into Salesforce.com. The file was given to me in all capital letters. How do I change the case globally so that it
is properly formatted with Ruth (capital first letter and the rest in small case) so that I do not have to go in and manually retype everything? (500+ lines)?
The =PROPER() function will do this for most records.
Let's say your data is in A2:G600
You then have to change the formulas to values using these steps:
NOTE: you need to carefully look through the results. Excel does not handle McDonald correctly - it will set it to Mcdonald. Check the "Mc" and "Van" records and manually correct these.
By Bill Jelen on 01-May-2002
MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.