For example: Column A has University of Hawaii Hawaii Community College Column B is currently blank, it is new. I want to populate it based on Column A's data. For example... If Row A has a string with "University" in it then I want Row B to say "University" If Row A has a string with "Community" in it, then I want Row B to print "Community" and I want this to happen for every instance of University or Community.
... View more