Hi vertisol, try - select the column of data>Data>Text to Columns>Delimited>Check the Space box and the 2 names will be separated into separate columns - you will need a spare column to the right of your data
_________________<font size=+1.<fontcolor="Blue">Sam</font size=+1.</fontcolor="Blue">
Why is it that the nuttiest people define reality? This message was edited by SamS on 2002-09-25 22:44
have a look at text to columns (data menu). it allows you to split a column of cells using delimiters such as spaces, commas etc. if there are spaces between firstname and lastname you can specify a space as the delimiter, then just reverse the position of the columns.
hth This message was edited by anno on 2002-09-26 00:16