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: 321
microsoft-excel
|worksheet-function
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