Community Forums 

Main Content

Split Field 'invoice_name' into two.

    Oct 28 2009 22:28:26


    Pat H

    Join date : 2009-08-01      Posts : 46

    Does any one know of a method or program to enable a mass way to split the field 'invoice_name' into two so you end up with say firstname and lastname. Then if you have say two Smiths, one John and the other Jack you can find them under Smith, John and Smith, Jack not John Smith and Jack Smith.

    Just Quizzes

    Nov 09 2009 22:32:18


    Ian S

    Join date : 2008-09-18      Posts : 164

    Hi Pat,

    Excel has a function to do this.

    In Excel 2007 its under the 'Data tab' - and is called the 'text to columns' function.

    Hope this helps


    Nov 09 2009 23:21:41


    Pat H

    Join date : 2009-08-01      Posts : 46

    Thanks Ian,
    I will investigate this. Could be very useful.

    Just Quizzes