- Nov 14, 2005
Hello. I'm in charge of creating a jury pool for the next trial and I'm hoping there is a macro or way that I can cut my data entry time in half. I have a sheet of 25,127 names that are all in one colomn, in this format (Smith, John J). I need them in three different colomns, each part of the name in it's own colomn. Is there a way I can automate this instead of cut and paste or retyping two of the fields? Lord please say yes...