text string extraction help please

  • Thread starter Thread starter prizefighter
  • Start date Start date
P

prizefighter

hi

i have a coloumn of names in different formats

example

Mr Paul Jones
Mr R Wright
Mr T H Jones

what i would like to extract is the first name if it is there or the
initials in to a seperate column

eg the column for the above would be

Paul
R
T H

thank you for any help and time you can give me

paul
 
Back
Top