Hi everyone,
How can i replace a certain part of text for and convert it to another form and then lookup the whole new value.
for example, Aquarius (T-500 ppm) B100 DYE to Aquarius 500ppmT B100 DYE and vice versa. Also, the bolded text is not fixed on a certain position (it can be at the beginning, end or middle of the text) and the number also differs.
also,i am using userform and the worksheet only contains the list of description that i will use as reference to lookup the value.
thanks.
Bookmarks