Is there a way that I can tell excel to put a suffix.
Say I have a cell which says "abc" I wish to have another cell which picks up the 3,4 or 5 letter and then puts .asx behind those letters.
I have tried the "if" statement (which is about the only function I can use without getting a massive headache) but can't get any results.
W2
