Sorry, that probably overdid it .. Just clean up the lookup col J will do,
with the TRIM down col L only, then a copy paste as values to overwrite
col J.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--