When data is retrieved from one of the programs, the data comes out in various formats.
example of several columns
John Smith
Alice Morris (Employee ID123)
Doug Martin, Matt Perry, Joey Terry
Frank Tran (Manager of Operations)
Doug Martin & Frank Warner
to format these cells into where names are separated by only commas/colons and non character giberish is removed, that would be ideal.
coworkers suggest importing into a database and then importing back into excel, but is there a way to do this in vba? or would I have to account for every name format and write a script to solve each particular case?
any suggestions would be great. thanks for reading.