Thanks Michael, made a temp Excel and it works just great. Will store the formula away for future use. Never thought to do this, must be old age. Did you cross post the item? Thanks Bob Cdn =========================================== Michael Brennan wrote: >Now place your curser in first empty Column immediately to the right of the column (not in the Headers) with your Names and in the Formula bar above enter the following formula: =RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) > >Now move to the next empty column and enter the following formula in the Formula bar: =LEFT(A1,FIND(" ",A1,1)) > >