Forum Discussion
Seth Pontiff
Nov 08, 2018Copper Contributor
Data Extraction
So forgive my ignorance in advance as I'm new when it comes to using Excel formulas. I know the basics, but now I'm needing to use more advanced features for my job. Right now I have a column of da...
Lorenzo Kim
Nov 09, 2018Bronze Contributor
unless you have a "dictionary" of medical terms to be referenced -
it would be very difficult to extract any word from a string with no definite patterns.
it would be very difficult to extract any word from a string with no definite patterns.
- Seth PontiffNov 09, 2018Copper Contributor
Supposing I did get a dictionary, what would be the next step?
- Lorenzo KimNov 10, 2018Bronze Contributor
pls find attached sample.
hope this helps
thanks..
- Lorenzo KimNov 10, 2018Bronze Contributor
pls see the attached file.
this is NOT case sensitive.
thanks..