Hi,

Excel 2003.

I have the following example text in Sheet1 cell A2 (it is pasted from
another application) :
AgentSmith Mary (12178)

It is made up of:
"Agent" - Constant text
"Smith" - Surname (Variable text and length)
"Mary" - Given name (Variable text and length)
"(12178)" - Identifying number (Actual number and length will vary. Brackets
will always be constant).


I would like to extract both the given and surname (proper case) and place
the result in Sheet2 cell B19, like so:
Mary SMITH

Any assistance would be appreciated.

Cheers

Bob