I'm not sure I understand exactly, what you did. And I'm not sure you understood exactly, what I adviced.

My advice was, to calculate a new field based on entry you got from other sources. I.e. you get some names as single text column, and the formulas split this single-column name to components, which you can use in your tables as they are, or you compose a stadardized full name column based on those. The formulas itself were an example, how to split non-standard full name for one hypothetical set of rules. You have to determine, which set of rules can be applied on your data, and to design formulas according them.

As you talk about conditional formatting, it looks like you try to use latter to indicate entries, which need editing. When so, then:
1. when you can design formulas for conditional formatting, showing faulty entries, then you always can design formulas to split entries too;
2. when you can design formulas to split entries, it doesn't always mean, you can design similar formulas for conditional formatting. Conditional Formatting has some limitations;
3. When you use conditional formatting, then you have manually edit all marked entries. When you split original entries and compose standard name, this work is not needed.

About coping data from web into excel - this is a path for disaster. Web resources often don't use conventional character set. P.e. they can use some unicode characters, which look like normal letters, but are coded differently. And databases and spreadsheets don't operate with character images - they operate with character codes. So when you read a character "A" from web, it may be not same as character "A" you typed into cell from keyboard. And for Excel, p.e. two seemingly identical words "And" and "And" may be entirely different (don't check on what I typed here).