Hi guys,
I'm an Excell virgin (almost) and I ran into a problem. I was given a report and in order to be able to work with it (and I will have to do it every day) I need certain text to be replaced or substituted. I have a very long list of students with particular courses they study in college (eg. BTEC lv2 Business, BTEC Lv3 IT, etc) and I would need those courses to be replaced by name of department (eg all business courses would change to simply to 'Business', all IT courses would change to IT) to be able to filter out particular department ...not only the course. Could you please help???
Thanks
Eva