• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1176
  • Last Modified:

middle name to middle initial in Excel

I am looking for a formula in Excel that will take a column full of middle names and keep only the first letter.  The file I extract contains full middle names, and the file I need to upload requires a middle initial only, with no period.

1 Solution
Ashish PatelCommented:
If you A1 cell is having a Middle Name value like Wolf
then paste this formula in B1 as =LEFT(A1,1)
and then stretch it to all rows and you will get Inititals in B columns
and then you can copy all values from there to another excel file.
ITRTMartinAuthor Commented:
Perfect!  Exactly what I  needed!

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now