I am trying to display a formula with text in the same cell, is that possible?
i tried concatenate but that only joins text.
i can't do it in the next cell, as the table format won't look right.
How can I display results if just the first 2 characters of both these fields: First name, Last name match?
eg.
1. cathy mcdonald
2. carmen mcfarlane
will be displayed as duplicates.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.