Excel 2007 - Adding line breaks in a cell and no line over 50 characters

Posted by Richard Drew on Super User See other posts from Super User or by Richard Drew
Published on 2012-07-05T19:32:56Z Indexed on 2012/07/06 15:18 UTC
Read the original article Hit count: 291

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

© Super User or respective owner

Related posts about microsoft-excel

Related posts about worksheet-function