I have notes stored in an excel cell. I add line breaks and dates every time I add
a new note. I need to copy this to another program, but it has
a line limit of 50 characters. I want
a line break for each new date and for when each date's comment goes over 50 characters. I'm able to do one or the other, but I can't figure out how to do both. I'd prefer words not to be split up, but at this point I don't care.
Below is some sample input. If needed for
a SUBSTITUTE or REPLACE function, I could add
a ~ before each date in my input as
a delimiter.
Sample Input:
07/03 - FU on query. Copies and history included. CC to Jane Doe and
John Public
06/29 - Cust claiming not to have these and wrong PO on query form. Responded with inv sent dates and locations, correct PO values, and copies.
06/27 - New ticket opened using query form
06/12 - Opened ticket with helpdesk asking status
05/21 - Copy submitted to
[email protected]
05/14 - Copy sent to
John Public and
[email protected]
Ideal Output:
07/03 - FU on query. Copies and history included.
CC to Jane Doe and
John Public
06/29 - Cust claiming not to have these and wrong
PO on query form. Responded with inv sent dates an
d locations, correct PO values, and copies.
06/27 - New ticket opened using query form
06/12 - Opened ticket with helpdesk asking status
05/21 - Copy submitted to
[email protected]
om
05/14 - Copy sent to
John Public and email@custome
r.com
