Had a hard time finding anything posted around this problem....Maybe it can't be done...
OK - here's what I want to do.
I have a table of data that has brands in it that have been manually entered.
For example:
Atlntc Cove
Atl Cove
Atlant Cov
I know that these are all Atlantic Cove brand....
Is there a formula that can be used that will print the full brand name?
Something like -
If BRAND is like Atlantic Cove then "Atlantic Cove"
Seems like a stretch to me, but maybe there's something, something...
Jeff