Hello dear excel masters
hope someone can assist me with this query. i have a list of product codes that have certain characters that i would like replaced to the "_" character. this following items i would like to automatically be changed to the _ (underscore) character
"."
"/"
"+"
" " "
" space character "
so for instance if i have the following product code
"NUA-MPRO1866R/16G"
i would like it to be "NUA-MPRO1866R_16G"
some product codes have multiple characters that i would like changed
example as follows
"VORTEX V4 404/WU"
this should become "VORTEX_V4_404_WU"
can this be done??
![smile.gif](/board/proxy.php?image=http%3A%2F%2Fwww.excelforum.com%2Fimages%2Fsmilies%2Fsmile.gif&hash=2b23f960121a0ec03857d042b98d59dc)
"."
"/"
"+"
" " "
" space character "
so for instance if i have the following product code
"NUA-MPRO1866R/16G"
i would like it to be "NUA-MPRO1866R_16G"
some product codes have multiple characters that i would like changed
example as follows
"VORTEX V4 404/WU"
this should become "VORTEX_V4_404_WU"
can this be done??