faq:remove_character_excel_routine
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
faq:remove_character_excel_routine [2009/11/16 15:54 (15 years ago)] – cliff | faq:remove_character_excel_routine [2010/06/09 16:44 (14 years ago)] (current) – andrew | ||
---|---|---|---|
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 30: | Line 32: | ||
* You will need to right click in the project window and choose Insert > Module. | * 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. | * 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 pane 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.1258415699.txt.gz · Last modified: 2009/11/16 15:54 (15 years ago) by cliff