i have 2 sheets that contain various data they have a a field in common
but they do not match completly
i need to import sheet 1 data to sheet 2
sheet 1 data is in the fomat VI123/45 sheet 2 data is V123
how can i get excel to look at sheet 2 data and import the compleat
number from sheet 1
thnx in advance
--
chris.howes
------------------------------------------------------------------------
chris.howes's Profile:
http://www.excelforum.com/member.php...fo&userid=5660
View this thread:
http://www.excelforum.com/showthread...hreadid=548905