Thread: automatically copy first 12 characters in one field to another?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Wolf Wolf is offline
external usenet poster
  
Posts: 19
Default 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.
Reply With QuoteReply With Quote