Hi!

I am in need of some VBA functionality in Excel and having no prior
experience at all in VBA, I am posting this here. Perhaps some can help me
out here. Thanks in advance for any attempts to get me started or for any
help you provide on this matter.

I have a list of words in Column A which need to be spilt up. For example if
column A contains:

AccountIsParentInstitutionAccount
AccountIsPatient
AccountIsSuspenseAccount
AdjustmentQuantity
AdjustmentReasonCode


The code should iterate through column A and take the word in a cell and
split it up. It should then insert that word in Column B. To make things
clearer, by using the above words as an example, column B should contain:

Account
Is
Parent
Institution
Patient
Suspense
Adjustment
Quantity
Reason
Code



A word doesnt need to be inserted again if it exists already. That is, if a
word exits, then skip it.

Thanks,
Anupam