Parsing LastName

[LuckyRaju]

I am having input like below. Last Name contains Middle Name and Last Name.  Few contains only last Name .

I need to get only Last name .  Middle name and last name can be separated by space or any special character.

Input : 

Last Name

S Kumar

N - Rao

A / Reddy

Raj

Selva Ram

Output: 

Last Name

Kumar

Rao

Reddy

Raj

Ram

[ShankerV · Accepted solution]

Hi @LuckyRaju 

One way of doing this.

([A-Z]+)$

Many thanks

Shanker V

[binu_acs · Accepted solution]

@LuckyRaju Another option

[nagakavyasri · Accepted solution]

Another way:

[Luke_C · Accepted solution]

Hi @LuckyRaju 

To offer a non-regex solution: