automatically copy first 12 characters in one field to another?
 

I am trying to write a formula that will automatically copy just the first 12
characters of a field into another field. I'm trying to isolate some
information.

automatically copy first 12 characters in one field to another?
 

if a1 contains your text, put this formula in e.g. in b2:
=left(a1,12)

Wolf

"JFletcher" wrote:

I am trying to write a formula that will automatically copy just the first 12
characters of a field into another field. I'm trying to isolate some
information.

automatically copy first 12 characters in one field to another?
 

You can use the worksheet function:
=Left(A1,12)
where A1 is the field you want...

You can also build this into code
Range("D1")=Left(Range("A1"),12)

The code leaves the result without the formula.

--
steveB

Remove "AYN" from email to respond
"JFletcher" wrote in message
...
I am trying to write a formula that will automatically copy just the first
12
characters of a field into another field. I'm trying to isolate some
information.