Forum Discussion

Dan Schwenk's avatar
Dan Schwenk
Copper Contributor
Nov 15, 2018

Conditional Formatting won't work on data pasted from internet

Hello,   I tried to find a solution to my problem through these conversations but have had no luck...   I am pasting data from a website (contact info such as Names, City, State, etc.) into a spr...
Conditional Formatting
excel
  • Dan Schwenk's avatar
    Dan Schwenk
    Copper Contributor
    Nov 15, 2018

    Hi Sergei,

     

    Thanks for the quick reply. I tried the CLEAN function and that did not work. I also checked the spelling, capitalizations and leading/following spaces, none of which are any different than the original column...any other thoughts? Would it help if I sent you the file or an example?

     

    Thanks,
    Dan

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 15, 2018

      Hi Dan,

       

      Yes, please remove sensitive information and attach to your post.

      • Dan Schwenk's avatar
        Dan Schwenk
        Copper Contributor
        Nov 15, 2018

        Attached is an example of what I was talking about. Column A is original data, Column C are example names pasted from the site (altered) and Column E is the same names from Column C except I typed them out individually (the flash fill feature popped up and I used that which actually worked pretty well). 

         

        As you can see, the name "Jackson Seagrave" is in all 3 columns but only highlights in Columns A and E. 

         

        I cannot distinguish ANY differences between C13 and A10/E13, hopefully you can.

         

        Thanks!

        Dan

Resources