1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Excel Help Needed

Discussion in 'Windows & Other Software' started by s1lkster, 10 May 2006.

  1. s1lkster

    Associate

    Joined: 3 May 2006

    Posts: 6

    I have the current cell in excel with the data input into it with the following format:

    Mr DAVIES Michael

    As I have over 4000 entries in this format I would like a macro or formula of some sort that will automatically reorganise the cell into the following format:

    Michael Davies
    or
    Surname and Forename into seperate cells.

    Also if the MR and MRS etc could be excluded from the output as this is not required.

    Thanks!
     
  2. Teifiterror

    Wise Guy

    Joined: 18 Oct 2002

    Posts: 1,155

    Location: Bromsgrove

    You could use the text to colums function in excel. Select the column containing your data. Then go to the data tab in the toolbar and select text to column. Click next and select spaces. Then click finish. This will seperate the data into seperate colums for you. ;)
     
  3. s1lkster

    Associate

    Joined: 3 May 2006

    Posts: 6

    thats ammmmmazing, thank you who ever you are

    love paul

    x x x x x
     
  4. Teifiterror

    Wise Guy

    Joined: 18 Oct 2002

    Posts: 1,155

    Location: Bromsgrove

    Told you i would figure it out :p