Thank You For your help...

However I want only FirstName and LastName

the logic would be for FirstName = From Left to ' ' (First Space)

the logic would be for LastName = From Rifh to ' ' (First Space)

Please advise...