In B1 put

=LEFT(A1,3)

Vaya con Dios,
Chuck, CABGx3



"edmos1" wrote:


so vlookup needs an exact search to look up from:

if I have a value = "aaa-US"
but I am trying to look up a value for "aaa"
I would have to systematically strip off the "-US"
I know I can do a find "-US" or crtl F
but any ideas on how I can create a formlula so I would have
Column A Column B
aaa-US aaa

Thanks D


--
edmos1
------------------------------------------------------------------------
edmos1's Profile: http://www.excelforum.com/member.php...o&userid=31903
View this thread: http://www.excelforum.com/showthread...hreadid=516304