Hello All,
I have a worksheet that I export from another program to Excel, the worksheet has one cell that contains all the resources required for scheduling appointments. Which are all separated by a semicolon. All of which have its location followed by an '@' symbol. The last resource does not have a semicolon.
I want to have a script that takes each part of this and separates them (like text to columns) but arranges them in predesignated columns based on the type of resource and location.
Any help on this would be much appreciated.
John
I have a worksheet that I export from another program to Excel, the worksheet has one cell that contains all the resources required for scheduling appointments. Which are all separated by a semicolon. All of which have its location followed by an '@' symbol. The last resource does not have a semicolon.
I want to have a script that takes each part of this and separates them (like text to columns) but arranges them in predesignated columns based on the type of resource and location.
Any help on this would be much appreciated.
John