using left command, 3 spaces over

[vascott01]

All:

Good morning..

I am using the following command
=LEFT(VLOOKUP(A6,info!$A$2:$O$217,14,0))

and the exported data that I paste into a worksheet (Tab) seems to have 3 spaces in the cell before it hits the word for the single character I want..

Is their a way to perform this

Thanks again

[NBVC]

You mean?

=LEFT(TRIM(VLOOKUP(A6,info!$A$2:$O$217,14,0)))

or

=LEFT(SUBSTITUTE(VLOOKUP(A6,info!$A$2:$O$217,14,0)),CHAR(016),"")

[vascott01]

wow that was fast and could you explain this CHAR(016) what is 016

thanks

actually the last command did not work too few arguments

[NBVC]

It is the code for a special "invisible char" (actually should be 0160) that oftentimes comes from downloading from emails or the web.

[vascott01]

thanks again