View Single Post
  #1  
Old June 1st, 2010, 12:56 AM posted to microsoft.public.excel.newusers
ROHIT
external usenet poster
 
Posts: 36
Default text column - via macro

Hi
Can someone write a macro for me to text column with the folloing

eg in Column A, I have 4602101 - AAAAABBBBBBBCCCCCC
so, I want macro to separate as put 4602101 in column A and the text in
column B