How do I truncate linked text?

  • Thread starter Thread starter Jenni
  • Start date Start date
J

Jenni

I am linking text from other worksheets, but I only want a portion of the
text to appear in the final document, using a certain number of characters.
Any ideas?
 
=left(sheet1!a1,12)
would grab the leftmost 12 characters of A1 in sheet1.

=right(sheet1!a1,22)
would grab the rightmost 22 characters of a1 in sheet1

=mid(sheet1!a1,5,32)
would grab 32 characters starting with the character in position 5 of a1 in
sheet1.
 
Back
Top