Apologies if explanation is not good?
I have some VB Code which I found (Function) - which converts "text" from a table into Array (checked in Immediate Window & list display what I want) - It does what I want but also converts the first letter of each word to Capital!
The "List" are all words / text in Capitals which I need to be in Capitals (e.g. COSHH, PPE etc.) in my other table
My question is: how do I convert the "Description" field if I type in coshh or Coshh to COSHH (which is in the Array)
Hope my explanation makes sense?
Thanks