User Tools

Site Tools


faq:remove_character_excel_routine

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Last revision Both sides next revision
faq:remove_character_excel_routine [2009/11/16 15:54]
cliff
faq:remove_character_excel_routine [2009/11/16 15:55]
cliff
Line 22: Line 22:
  
 Below is an example of an excel sheet where there are a couple part numbers that have some unwanted characters. In this case a "​-",​ or minus sign. The goal of the code above will be to remove all of the unwanted characters. Below is an example of an excel sheet where there are a couple part numbers that have some unwanted characters. In this case a "​-",​ or minus sign. The goal of the code above will be to remove all of the unwanted characters.
 +
 {{faq:​01-exampleexcel.jpg|}} {{faq:​01-exampleexcel.jpg|}}
 +
  
 The screen below shows what you will see as you impliment the visual basic function. To start with you are going to need to open the visual basic editor: ​ The screen below shows what you will see as you impliment the visual basic function. To start with you are going to need to open the visual basic editor: ​
Line 31: Line 33:
   * This will bring up the Modules section in the project viewer and add Module1 to the view.   * This will bring up the Modules section in the project viewer and add Module1 to the view.
   * Paste the code from the code window above into the blank pain on the right. Your screen should now look very familiar to the screenshot below.   * Paste the code from the code window above into the blank pain on the right. Your screen should now look very familiar to the screenshot below.
 +
  
 {{faq:​02-macroinvbeditor.jpg|}} {{faq:​02-macroinvbeditor.jpg|}}
 +
  
  
 Now enter the formula as in the image below to test the operation of the formula. Now enter the formula as in the image below to test the operation of the formula.
 +
 +
 {{faq:​03-formulaexample.jpg|}} {{faq:​03-formulaexample.jpg|}}
faq/remove_character_excel_routine.txt ยท Last modified: 2010/06/09 16:44 by andrew