From: Gord Dibben on

TRIM and CLEAN won't clear the 0160 non-breaking space if that's what the
problem is.


What: Alt + 0160

With: nothing

Is the only way to clear the nbsp


On Fri, 8 Jan 2010 13:31:02 -0800, Luke M <LukeM(a)>

>Your formula is correct in syntax and structure.
>Is it possible that there are extra spaces in the name that are causing
>errors? For example, if T2 contains "New York " this would cause the formula
>to fail (or unprintable characters, if info was copied from outside source
>like the internet). If so, you might try: