I recommend using Splitter for Microsoft Access. It's a handy utility and is designed to handle
the issue that Albert mentioned. You can also add new data, such as new first names or difficult
to split last names to its database. This way, if it fails to correctly split a name the first
time around, you'll have a good shot at doing it successfully on a subsequent test if you add the
new data to its database.
http://www.infoplan.com.au/splitter/spDownload.htm
The author of this utility, who is based in Australia, has always been very responsive to my
inquiries and suggestions for improvements.
Tom
______________________________________________
There certainly is a way to do this. The real problem is how do you know the
2nd value is a persons initials, or the last name?
Albert D. Kallal
Albert Kallal
Some names will have 2 values...some will have 3...and you likely will have
to deal with this.
If you are using access 2000 and later, then you can use:
strTest = "Albert D. kallal"
debug.Print split(strTest," ")(0) = Albert
debug.Print split(strTest," ")(1) = D.
debug.Print split(strTest," ")(2) = Kallal
--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
[email protected]
http://www.attcanada.net/~kallal.msn
______________________________________________
I need to seperate first and last names from one cell
I can not use the text to columns function in this case
is there a formula that can pull first word
second word and third word from one cell
