View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chad[_3_] Chad[_3_] is offline
external usenet poster
 
Posts: 32
Default Copying part of a string to another cell

Hi All,

Is there an easy way to do this?
I want to copy the first 6 characters from [A1] to [K1], [A2]..[K2] all the
way to last row.

I am assuming I will have to use a loop and use the Left command. I was
just hoping for an easier way since it is the entire column.

Chad