P
Pete McCosh
Joe,
to replace the original completely, try
Data> Text to Columns...
If you have your name in A1 and wish to preserve that, the
following formulae in B1 & C1 will do the job:
B1 =LEFT(A1,FIND(" ",A1))
C1 =RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
Although this second method will start to break down if
your list includes names such as "Dick Van Dyke" ...
Cheers, Pete.
to replace the original completely, try
Data> Text to Columns...
If you have your name in A1 and wish to preserve that, the
following formulae in B1 & C1 will do the job:
B1 =LEFT(A1,FIND(" ",A1))
C1 =RIGHT(A1,LEN(A1)-FIND(" ",A1,1))
Although this second method will start to break down if
your list includes names such as "Dick Van Dyke" ...
Cheers, Pete.