Intentionally truncating text characters
 

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!

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!

Intentionally truncating text characters
 

Fantastic. Thanks!

"Gord Dibben" wrote:

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