Hi all,
I have been searching for vba code that could extract multiple string which begin with the symbol "$".
However the pattern for the text is valid, sometime have a few hyphen "-", sometime only 1 hyphen "-".
Sometime it end with a spacing sometime is not.
Another condition would be, if the string contain multiple text begin with "$", need to auto add another cell below then extract the text.
For example:
ORIGINAL:
Name Type
A ( $WERT-X1-ERT - $RFV-XC )
B $QAZ-OKP - ( UJN-HHJ-:OPK )
C (( RFG-IJN-ERTTY + $IJKKL-RF-ASDFG - $VGT-BN6678 ) / $NJIO-ZXC6789
D ( HUJB-BN-MN ) - $UJ-HJI876
EXPECTED RESULT:
Name Type
A $WERT-X1-ERT
A $RFV-XC
B $QAZ-OKP
C $IJKKL-RF-ASDFG
C $VGT-BN6678
C $NJIO-ZXC6789
D $UJ-HJI876
I have been searching for vba code that could extract multiple string which begin with the symbol "$".
However the pattern for the text is valid, sometime have a few hyphen "-", sometime only 1 hyphen "-".
Sometime it end with a spacing sometime is not.
Another condition would be, if the string contain multiple text begin with "$", need to auto add another cell below then extract the text.
For example:
ORIGINAL:
Name Type
A ( $WERT-X1-ERT - $RFV-XC )
B $QAZ-OKP - ( UJN-HHJ-:OPK )
C (( RFG-IJN-ERTTY + $IJKKL-RF-ASDFG - $VGT-BN6678 ) / $NJIO-ZXC6789
D ( HUJB-BN-MN ) - $UJ-HJI876
EXPECTED RESULT:
Name Type
A $WERT-X1-ERT
A $RFV-XC
B $QAZ-OKP
C $IJKKL-RF-ASDFG
C $VGT-BN6678
C $NJIO-ZXC6789
D $UJ-HJI876