remove first letter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
This might suffice ..
Put in D2: =MID(B2,2,99)
Copy down. Copy col D and overwrite col B with a paste special as values.
Delete col D.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract letters from a cell 2
Separate first name, middle name and last name 2
Use Len and Left to make name 3 letters 2
Pulling only first name 3
Easy one... 7
complicated text to column 4
Formula To Split Name 5
parse text string 4

Back
Top