faq:remove_character_excel_routine
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
faq:remove_character_excel_routine [2009/11/16 15:47 (15 years ago)] – cliff | faq:remove_character_excel_routine [2009/11/16 15:54 (15 years ago)] – cliff | ||
---|---|---|---|
Line 21: | Line 21: | ||
</ | </ | ||
+ | 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: | ||
+ | * 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: | {{faq: | ||
+ | |||
+ | 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