I need macro to cleanse Users column in following table.
My requirement is to split users column and extract user names between single quote ' and then create new record by copying those users in Owner column with DateTime and FileName as same.
There may or may not be users in in Users column...