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
