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
