Hi all

1. is there a function to count the characters in a cell?
i.e. if I had the word "abra44" in cell A1 the function would return 6
2. I haveto match up words from column A to words in row 1
but its not an exact match, I need the last 5 letters of the values in row 1
ignored.
ie. i need to match up

abc

to a value in array of

abd 12345
abc 12345
abf 12345