I have unsuccessfully searched the web over for possible solutions to this problem, let me see if I can describe it...
I have a data set with a column medical codes that have extra characters and things on the beginning or/and or end of the string and a separate data set with a column that contains valid codes. I want to be able use a formula to fix the codes with extra characters so that they return the valid code that is a part of the messy code. Basically, I'm thinking I could accomplish my goal if I could create a formula that said something like this "if a cell contains consecutive characters that match anyone of the strings in this column return the match from the column". Maybe something with INDEX or MATCH???
For example I have code FARJ34561, the valid code that I want it to be is J3456.
Hope that makes sense,
Thanks!
Bookmarks