Hello,
I have a data table with four fields and approximately 2,500 records that I've been asked to format in a particular manner and I'm struggling with how to do so without writing a macro. The problem is, I'm not very good with VBA and am struggling with how to even start it out. Any help anyone can provide would be greatly appreciated.
Four Fields in the table:
File Number: Unique Alphanumeric Record
Owner: One Name
To: email addresses seperated by semicolon then a single space
CC: email addresses seperated by semicolon then a single space
The format I've been requested to provide, is for all email addresses in the To and CC fields be aligned to the left in one cell as if the text was wrapped, only with clean breaks after the semicolon. Here's an example:
Data layed out in one cell:
mike@abc.com; sean@abc.com; tom@abc.com
want to see it one cell as:
mike@abc.com;
sean@abc.com;
tom@abc.com
Some rows have multiple addresses, others only one and none in the CC. The only consistent component is the fact that they are seperated by a semicolon and single space. The only way I know how to complete this task is to go through them one by one and use the alt enter command.
Any help anyone can provide for an alternate solution would be much appreciated!
I have a data table with four fields and approximately 2,500 records that I've been asked to format in a particular manner and I'm struggling with how to do so without writing a macro. The problem is, I'm not very good with VBA and am struggling with how to even start it out. Any help anyone can provide would be greatly appreciated.
Four Fields in the table:
File Number: Unique Alphanumeric Record
Owner: One Name
To: email addresses seperated by semicolon then a single space
CC: email addresses seperated by semicolon then a single space
The format I've been requested to provide, is for all email addresses in the To and CC fields be aligned to the left in one cell as if the text was wrapped, only with clean breaks after the semicolon. Here's an example:
Data layed out in one cell:
mike@abc.com; sean@abc.com; tom@abc.com
want to see it one cell as:
mike@abc.com;
sean@abc.com;
tom@abc.com
Some rows have multiple addresses, others only one and none in the CC. The only consistent component is the fact that they are seperated by a semicolon and single space. The only way I know how to complete this task is to go through them one by one and use the alt enter command.
Any help anyone can provide for an alternate solution would be much appreciated!