Hi,


I have a number of different spreadsheets that I need to impirt into a
single database. Unfortunately some of the information is in different
formats.


Would anyone be able to provide me with a solution that can turn:


A B Brown
ABC Brown
*A B C*Brown*
Brown, A B
Brown, Anthony Bernard
Brown Anthony Bernard
Mr A B Bernard


Into separate fields for title, forename, initials & surname


On a similar theme I also need to do much the same thing with
addresses:


1 Victoria Road, Victoria, Victoriashire, VC1 1VC


etc


And lastly (for now anyway) I also have some dates that I need to
convert from:


01012004 (dd/mm/yyyy)
112004 (d/m/yyyy)
20040101 (yyyy/mm/dd)
200411 (yyyy/m/d)


to 01/01/2004 (dd/mm/yyyy)


Hope someone can help


cheers