Hi,
I have a list containing names which came from multiple sources. All the names from one source came in as all CAPS, and I want to remove those. Is there any way I can filter so that I don't see any rows where the name is all CAPS?
Thanks!
Hi,
I have a list containing names which came from multiple sources. All the names from one source came in as all CAPS, and I want to remove those. Is there any way I can filter so that I don't see any rows where the name is all CAPS?
Thanks!
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
Here you go. Pretty straight forward, just need to remove any of the names that are all uppercase
You could use a formula and the autofilter:
Row\Col A B C 1 Current List Upper? 2JACK 1B2: =--EXACT(A2,UPPER(A2)) 3Jon 0 4JOE 1 5JILL 1 6Jeff 0 7JERRY 1 8Joan 0 9John 0
Entia non sunt multiplicanda sine necessitate
shg, you are a genius!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks