|Rating(1-10)||Knowledgeability = 10||Clarity of Response = 10||Politeness = 10|
|Comment||Thanks so much Mr. Ogilvy. I will give it a try. In the meantime I continued to research and eventually found that a macro isn't even needed. I just added a column beside the column I wanted to change and entered the following formula: =LEFT(J7,LEN(J7)-1) Where J7 is the address of the sell that I wanted to truncate. It worked very well too! Thanks again for your help. This is an amazing service. Jim G.|
Answers by Expert:
Selected as an Excel MVP by Microsoft since 1999. Answering Excel questions in Allexperts since its inception in 2001. Able to answer questions on almost all aspects of Excel's internal capabilities. If seeking a VBA solution, please specify that in your question itself so I give you the answer you want. [Excel has weak protection - if you are distributing an application, I don't answer questions on how to protect your project from your users.]
Master of Science (MS) degree Operations Research (ORSA)
Awards and Honors
Microsoft MVP in Excel.