Hi Frank

just wanted to tell you, that Gord's solution is pretty neat, although
you have to pay attention.
The way your data is set up right now, the lastname of your
2piecenames and the middlename of your 3piecenames will be in the same
column....maybe not the best if you want to export the data to a
database, as you said in your first post.

In my first post i gave you formulas for all 3 columns, which will put
the last name always in column d and fill out column c (middlename)
only if there is a middlename.

Cheers Carlo

If you have other questions, just ask.

On Dec 19, 10:40 am, Frank Situmorang wrote:
Thanks very much Gord, you gave me a simple way.

--
H. Frank Situmorang



"Gord Dibben" wrote:
Frank

Maybe you could work with DataText to ColumnsDelimited by space.

Gord Dibben MS Excel MVP

On Tue, 18 Dec 2007 01:21:00 -0800, Frank Situmorang
wrote:

Thank you Gary, I will give a try- Hide quoted text -

- Show quoted text -