On Wed, 5 Jul 2006 15:08:42 -0500, drewannie
wrote:


How can I separate a column of cells containing a single text string in
each[these are names formated as a string with no delimiter as in
"FirstLast" with the first letter of first and last name capitalized
and the rest lower case...] into two columns of text called Firstname
and Lastname?

Thanks!:)

Download and install Longre's free morefunc.xll add-in from
http://xcell05.free.fr/

Then with

A1: FirstnameLastname

Firstname: =REGEX.MID(A1,"[A-Z][^A-Z]+")
Lastname: =REGEX.MID(A1,"[A-Z][^A-Z]+",2)



--ron