Hello,
I am new to this forum, and am a beginner Excel user.
I have a list of 186k position titles in a column that have been manually entered by various people in a survey. The text is all over the place in terms of punctuation, spaces, capitals, etc..
I want to analyse this text, looking for certain key words or partial text (like “director”/"direct" or “president”/"pres", or “treasurer”/"tres" for example) and assign a code in another column. This will allow me to collapse the list into a manageable range of say 10-20 position titles, with the remainer coded as a particular value for "other".
I have been looking on-line but I don’t see a solution that would suit my purposes. I was thinking it would be a macro with multiple “if” statements resulting in multiple codes in an adjacent column (the position titles I am interested in), else “other” (with its own code value).
I am in a time crunch otherwise I could take my time to try and find a solution on-line.
Do you know how I would do this?
Thanks in advance for any help you could offer.
Tania
Bookmarks