Hello...
I have a problems here. The problems is attached in the file. I wanna extract alpha/char from a string. Example: I wanna extract the words "(M)" with the bracket from the string "Toothbrush (M)" in column A. After extracting the (M) out, I wanna do a validation to compare the (M) in column B with another data in column C, if the (M) is same as the data called "Medium" in column c, the validation will return "Match" in the column d!
Can anyone help me out? Thanks you very much! Yr help is greatly appreciated!
The file can be downloaded from here:
http://h1.ripway.com/suaiko9999/test.xls
I have a problems here. The problems is attached in the file. I wanna extract alpha/char from a string. Example: I wanna extract the words "(M)" with the bracket from the string "Toothbrush (M)" in column A. After extracting the (M) out, I wanna do a validation to compare the (M) in column B with another data in column C, if the (M) is same as the data called "Medium" in column c, the validation will return "Match" in the column d!
Can anyone help me out? Thanks you very much! Yr help is greatly appreciated!
The file can be downloaded from here:
http://h1.ripway.com/suaiko9999/test.xls
