Forum Discussion
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...
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
Hi Dan,
Yes, please remove sensitive information and attach to your post.