faq:remove_character_excel_routine
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
faq:remove_character_excel_routine [2009/11/16 15:54 (15 years ago)] – cliff | faq:remove_character_excel_routine [2009/11/16 15:55 (15 years ago)] – 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 " | Below is an example of an excel sheet where there are a couple part numbers that have some unwanted characters. In this case a " | ||
+ | |||
{{faq: | {{faq: | ||
+ | |||
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: | {{faq: | ||
+ | |||
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: | {{faq: |
faq/remove_character_excel_routine.txt · Last modified: 2010/06/09 16:44 (14 years ago) by andrew