Prev: @which function to use when
Next: SIMPLE CONCATENATE FUNCTION
From: Gord Dibben on 8 Jan 2010 18:04
Luke

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

Edit>Replace

What: Alt + 0160

With: nothing

Is the only way to clear the nbsp


Gord

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

>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:
>
>=VLOOKUP(TRIM(CLEAN(T2)),StateCodes!$A$1:$B$50,2,FALSE)

First  |  Prev  | 
Pages: 1 2
Prev: @which function to use when
Next: SIMPLE CONCATENATE FUNCTION