how to keep the first initial of a name &delete the rest in cell

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

Guest

how to keep the first initial of a name and delete the rest of the character
in a cell.
Etc. "Mike" the result should be "M", "Darlene" should be "D"
 
If your name cell is A1 then write this formula in B1:
=LEFT(TRIM(A1),1)

That will enter the first character from the entry in A1 into B1. You
could then copy all the entries in B1 and paste them over A1 as
values, and delete entries in B as needed.
 
One way, assuming many cells in a column:

Choose Data/Text to Columns. Select Fixed. Click Next. set a break
between the first and second character. click Next. Select the
right-hand column(s) and select the Do not import (skip) radio button.
Click Finish.
 
You must log in or register to reply here.

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 first numeric characters only??... 7
Can I delete a portion of cell contents repeating in multiple fie. 1
How to lookup based in the first 3 characters of a cell 2
How to make a macro run on the next cell 2
Formula to validate characters within a string of data in aparticular cell 1
fill any random cell in a column and block all other cells 5
Cut the last 20 characters out of a text string 4
check first 3 characters of a cell and compare to a table 4

Back
Top