Thank you, so

NA: Right([Field6],Len([Field6])-InStr(1,[Field6],"Unit")+1)

is equeal to this

RIGHT([Field6], LEN([Field6]) - CHARINDEX('Unit', [Field6]) + 1)

or this

SUBSTRING([Field6], CHARINDEX('Unit', [Field6]), 100)

right?

Your recomendation to use this:SUBSTRING([Field6], CHARINDEX('Unit', [Field6]), 100) right?