Results 1 to 3 of 3

Thread: excel macro

  1. #1
    Guest

    Default excel macro

    I have a large spread sheet of pupil information (600 records). It's been created with two bits of info in one field in the following format <firstname,surname>. Can any one come up with a macro to write the two values to new columns and dump the ','. I will beat the person responsible.
    Ta
    Rob

  2. #2
    Guest

    Default Re: excel macro

    That's interesting - when I posted the message a few minutes ago I included the string I couldn't seperate between a pair of angle brackets - and the string didn't appear in the message! The problem entry looks like this (firstname,surname) - without the brackets.
    Thanks in anticipation
    Rob W

  3. #3
    Guest

    Default Re: excel macro

    Hi Rob

    You probably don't need a macro. Insert a column to the right of the one that has the info in it. Hightlight the column that has the info in it and then click on Data/Text to columns. Choose delimited and click on next.
    Check 'commas' for the delimiter and click on next. Clickk on Finish.

    That should do the job.

Similar Threads

  1. Excel Macro
    By GrahamB in forum PressF1
    Replies: 3
    Last Post: 09-05-2008, 03:37 PM
  2. Macro Excel
    By BoutFam in forum PressF1
    Replies: 4
    Last Post: 12-11-2005, 08:39 AM
  3. Excel Macro
    By in forum PressF1
    Replies: 1
    Last Post: 11-09-2001, 01:03 PM
  4. Excel Macro
    By in forum PressF1
    Replies: 0
    Last Post: 29-10-2000, 10:37 AM
  5. Excel macro
    By in forum PressF1
    Replies: 0
    Last Post: 06-09-2000, 04:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •