B
Bob Maloney
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
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