Invert last name / first name (not comma separated)

Hi,

I was wondering if anyone could point me in the right direction on this. Basically I have a dataset in which the names are stored in the format DOE John. The designated last name is always in Upper case and the first name is always in Proper case. What I would like to do is cycle through each cell and switch the Uppercase word(s) with the Proper case ones.

A secondary problem is that some of the cells contain two values. These are separated by commas so pretty easy to parse and deal with, but I'm unsure again of the best way to approach this. Ideally I want to process everything in the cell at once and I have no need to map the second values (where they occur) to a new field.

Any help would be greatly appreciated!!

Kieran

PS

Here's a small sample of what I'm up against:

PAWEEN PURIJITPANYA Yongyoot Thongkongtoon,PARKPOOM WONGPOOM Banjong Pisanthanakun
COLELL Judith
TSUKAMOTO Rempei
ROMANO Peris,SOROGOYEN Rodrigo

Just make them Proper case ?

Please Login or Register  to view this content.

Maybe try this one :

Please Login or Register  to view this content.

Charlize

Hi ,Yet Again!!

Please Login or Register  to view this content.

Regards Mick