Intentionally truncating text characters
=LEFT(A1,35) entered in B1
Gord Dibben MS Excel MVP
On Thu, 21 Jun 2007 15:34:00 -0700, Doug wrote:
How do I copy text (not data) from one column to another (presumably using a
formula), only truncating the copied info at a specified character length?
For instance, if one column contains 80 characters, I'd like to truncate it
at say, 35 characters.
Thanks!
|