Xor, you clearly know your marbles. CONCATENATE does the same thing, it makes the spreadsheet look for 35 in Columbia A and not 3 and 5 in different columns. But i can work with what you have already given me so thats great. thanks again.