Character Returns

  • Thread starter Thread starter Hendy
  • Start date Start date
H

Hendy

Hi,

I am trying to make a formula that allows me to type up to 19
characters in f5, but return 70 characters in cells below it in E12 an
E13. I want the text to break after 35 characters in E12 and continue i
E13 with "..." as the last 3 characters. Simular to a PPC ad.

Thank for you help.

Hend
 
Hendy,

You could put into E12 =LEFT(F5, 35) & "…"
And in E13 put =MID(F5,36,35)

This will chop a word that spans the 35th character, midword. It'll take a
fancier formula to complete the word (or maybe stop at the beginning of that
word), if you need that.
 
Hi
this is not very patient: Bumping after 11 minutes.
for your question look at the
MID and LEFT
functions
 
Back
Top