View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lupe Lupe is offline
external usenet poster
 
Posts: 30
Default remove first letter

Hi,
Maybe the solution for my question is already posted, but I cannot seem to
find it at the moment. I have a list of names with first name, initials and
last name. From the column of initials I need to delete the first initial,
which includes the initials of the first name and all others that follows. So
my file is somewhat like this:
First name Initials Last name
Mary MJA Sand
Lupe LM Antonisia
Laurine L Jans

My new list should be:
First name Initials Last name
Mary JA Sand
Lupe M Antonisia
Laurine Jans

Hope someone can help me.
Thanks & Regards, Lupe