Question Locked

Excel - How to reduce the length of a text in a field?

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a bunch of middle names in a column in an Excel spreadsheet and I just want to have the middle initial. How do I reduce the name to just one letter?
Ex. David > D

I know there's gotta be some easy formula out there for this...

Thank you!!

2 replies

by thumbsup2

Supposing you have the following structure:

Column A = First Name
Column B = Middle Name
Column C = Last Name

In Column D, type =LEFT(B1,1)
This will place the first character of the contents of Column B into Column D on the same row.

Now, copy cell D1 down to the bottom of the list in Column D and you're done.

This discussion is closed to new replies.