View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 2,069
Default Create a macro to move info from one column to another

I have a list that has first names and middle intiials in the same column. I
want to create a macro to cut the initial and the period and paste it into
the next column over.

I have recorded a macro that does it, once. But I don't understand how to
get it to keep working through the whole list.

Thanks.
--
John