I have an excel sheet saved as .CSV. COLUMN A has a code number that does not change for all of the 1000+ entries. Column B has last name first name. Column C has unique id numbers for the names.

I an trying to import the names and id numbers into another program but the problem is that it is looking for separate entries for first and last names. I can not change what it is looking for.

Is there a formula that will see the first word in Column B and move everything after it into a new column? If not move, then I am pretty sure that it would work if it was just copied. I can insert a new column so that C becomes D.

ThanksWish I could help. Been a long time. Once I have a had job and I had to CREATE some new functions. I believe it was a form of Visual Basic, or something like that. You create a function and use it to create new entries in new cells. The LANGUAGE can do strings as well as numbers. Is that any help at all? You should be able to use the Text to Columns function. With reference to Excel 2003, select column B, then, on the menu, select Data, Text to Columns, and proceed through the screens. THANKS Soybean, that is exactly what I was looking for. A little tweaking of the final product and it is perfect. Soybean's the man !