Forum Discussion
comparing 2 columns
I have 2 columns that I need to compare.
some values in Column A have the acronyms and column B has the full name. Example Col A has NBC and B has National Bradcasting corporation. so when I compare the 2 columns, I want it to pass. How do I do that?
You might use a helper column that constructs the acronym from the full name:
The formula in C2 is
=CONCAT(LEFT(TEXTSPLIT(B2, " ")))
