Hi guys, I'm hoping someone can help with the following excel problem - or at least tell me it's not possible!

I have a database of customers and company names which I'm trying to sort through and arrange for a marketing campaign.

Presently, as the database comes to me, their naming details are all contained in column "A" separated with comma's- for example:

JONES,TONY
BROWN,JOE S
COMPANY,THE INDUSTRIAL COMPUTING
SHOP,THE OUTSIZE
TRUST,TWO TREES
WILLIAMS,MARK T R & JOHN W

Etc.

I need to have the customers "first name" in column "A" and "last name" in column "B". If the name is not a person (ie: a Trust or a company), I need it to simply insert "Sir or Madam" in Column "A" and leave column "B" blank.

A lot to ask I know, but I have several thousand entries and it'll take me days to go through each one to do this manually.

Any help would be appreciated.

Thankyou.