Hi Kim and Jeff, The CSV and Notepad method is fine if you've got a small amount of data (say a screenful). If you've got more, I think it's worth creating a formula: If cell A2 is Kim PASQUILL then MID(A2,1,FIND(" ",A2)-1) will give you Kim and RIGHT(A2,LEN(A2)-FIND(" ",A2)) will give you PASQUILL However, if A2 was, say, Peter Laurence DAUNCEY, the first formula would give you Peter, but the second would give you Laurence DAUNCEY. There are ways around this, but depending on the data you've got, you may well prefer Jeff's method. Happy Easter! Peter