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 compa...
You might use a helper column that constructs the acronym from the full name:
The formula in C2 is
=CONCAT(LEFT(TEXTSPLIT(B2, " ")))