How do I truncate linked text?
 

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?

How do I truncate linked text?
 

=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.




Jenni wrote:

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?

--

Dave Peterson