Quote:
Originally Posted by deef-thp
.. because the goal is to display a bunch of text on in a single row, without screwing up your column widths?
|
actually what I am doing is trying to copy ads from a Yahoo campaign to AdWords and they have 100's of ad creative. So Yahoo allows you to have one line at 70 characters and AdWords is 2 lines at 35 characters.
I have this forumla, but trims off the last word, I was hoping it would trim the space before the 35th character:
Code:
=LEFT(C2,FIND(CHAR(35),SUBSTITUTE(C2," ",CHAR(35),LEN(C2)-LEN(SUBSTITUTE(C2," ","")))))