I need to break up a column of text that holds a combination of strings
and numbers. The problem is that the lines of text are not uniform. For
instance:

John Doe 123 23 Los Angeles California
James E Smith 23 1234 Austin Texas


How can I break up the text into columns as if it the text was comma
delimited like this:

John Doe, 123, 23, Los Angeles, California
James E Smith, 23, 1234, Austin, Texas


Thanks.


--
ericsh
------------------------------------------------------------------------
ericsh's Profile: http://www.excelforum.com/member.php...o&userid=26149
View this thread: http://www.excelforum.com/showthread...hreadid=537544