Can you post some examples of what you have and what you are trying
to do?

Pete

On Oct 2, 2:33*pm, Steve Salzman <Steve
wrote:
Dave,

I'm trying to use a lookup function to return some data. *Unfortunately, the
data being looked up can occur in 1 to 5 character long. *how do this lookup
without doing a find and replace on the first "-" (which is where i want to
stop my lookup) with 5 to 10 spaces? *Then doing the lookup that way...
There's got to be a better way