Hello,

I'll have a look at this soon, will a new word always start with a capital
letter?, will the first character of a new word always be an alpha caharacter
or will it ever be a number.
If you could tell me what it is that you are really trying to do it may save
a lot of time and effort. (Give us an overall picture of what you would like
to do).

Chas

"spartacus13210" wrote:

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