Prev: IF Formula
Next: return 0 if cell has data?
From: Jenni on 9 Apr 2010 12:51
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?
From: Dave Peterson on 9 Apr 2010 14:10
=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
 | 
Pages: 1
Prev: IF Formula
Next: return 0 if cell has data?