Auto fill the cell with a value and replace underscores with "dash" and "blanks"

Hello Forum,
I have a workbook with 2 dropdown lists in selection tab.
Is there a way to?
Populate quantity zero into quantity column when "Yes" is selected in “8 group” column (G4)
And in G4
Remove first 3 characters
Replace underscore between 5 and A with a "dash"
Replace all remaining underscores with "blanks"

Please see attached file

Thank you for your help.

Hi Richard,
Yes, you are correct.
Thank you for your help.
Kidprojects

Hi Richard,
This may clearer what I want for the long description.

Remove first 3 characters
Replace underscore between 5 and A with a "dash"
Replace all remaining underscores with "blank"
When the Qty > 0 is selected in H column.
Ex:
12435-ABC SINGLE MODULE SHELF RLY
67890-DEF DOUBLE MODULE LCD 4CH
Thank you

Hi Richard,
I download the workbook to test but it's not working.
Code screen shot.jpg
Below is the code that I have been working with but I cannot put a "dash" between 5-A and 0-D
12435-ABC SINGLE MODULE SHELF RLY
67890-DEF DOUBLE MODULE LCD 4CH

Please Login or Register  to view this content.

Could you modify this code to put a "dash" between # and letter?
Thank you for your help.

Hi Richard,
The reason I try to modify your code is the original did not work after I download your file and tested. I will try with your original code with the adding Target = Replace.
Thank you

Originally Posted by Kidprojects

Hi Richard,
The reason I try to modify your code is the original did not work after I download your file and tested. I will try with your original code with the adding Target = Replace.
Thank you

Hi Richard,

How are you?

I am finally understood how it works.

1)********* Select the choice from dropdown list in column G

2)********* Select the QTY from the dropdown list in column H

3)********* Go back to the dropdown list in column G

4)********* Select “Yes” to remove first 3 characters, replace underscore between number and letter with a “dash” and replace all remaining underscores with “blanks”

Your code is brilliance to do all that changes but my goal is little bit different*

1)********* Select “Yes” in column G, zero is auto populated in column H

2)********* Select any choice from the dropdown list in column G (other than ”yes”)

3)********* Select any QTY from the dropdown list in column H to:

Remove first 3 characters, replace underscore between # and letter with a "dash" and replace all remaining underscores with "blanks" when The QTY is selected in column H

*

My modified code is working with above three except it cannot replace underscore between number and letter with a "dash" because I don’t know how to put just a “dash” as a replacement between number and letter in my modified code. Could you please help to fix this code to do that replacement? So sorry for my bad explanation and attached is my new file with the modified code

Your help is greatly appreciated.

Cheers

Kidprojects

Sucuri is preventing me to upload the new file, hopely you still can fix the modified code that I posted in previous reply.

Hi Richard,
Here is my update file.
Thank you,
Kidprojects