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 revisionPrevious revision
Next revisionBoth sides next revision
faq:remove_character_excel_routine [2009/11/16 15:47 (15 years ago)] clifffaq:remove_character_excel_routine [2009/11/16 15:54 (15 years ago)] cliff
Line 21: Line 21:
 </code> </code>
  
 +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: 
 +  * In excel go to the tools menu > Macro > Visual Basic Editor
 +  * The shortcut for this is ALT+F11
 +  * The screenshot below will apear, less the Module1 and the Function code for Function cmRemChar. 
 +  * You will need to right click in the project window and choose Insert > Module.
 +  * 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.
  
 {{faq:02-macroinvbeditor.jpg|}} {{faq:02-macroinvbeditor.jpg|}}
  
 +
 +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 (14 years ago) by andrew