How do I use = command on only first few letters or so?

B

Brett

How do I setup a formula where the equal command checks only the first letter
or so.

For example, I have a list of companies that I want to screen for
duplicates, so I would have Excel place a 1 next to duplicate entries for
sorting and then deleting. But the formula always misses things like this:
Games, Inc.
Games
How can I set it up to only look at the first few letters or so?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Keep First Letters, with exceptions 0
Improving Macro That Keeps First Letter 0
Style Gallery View 3
Need Help Creating a Word 2010 Chistmas Letter Template 8
How do I post date a letter? 1
Copy first few letters from a cell 9
Capitalize only first letter in sentence 0
How do I clear a form? 0

Top