+ Reply to Thread
Results 1 to 4 of 4

Excel 2003 Formula or Edit/Replace to delete middle initials not working

  1. #1
    Registered User
    Join Date
    06-22-2012
    Location
    New Brunswick, NJ
    MS-Off Ver
    Excel 2003
    Posts
    53

    Excel 2003 Formula or Edit/Replace to delete middle initials not working

    I have a list of names some with middle initials with a period after them and some that do not have a period after them. In the past I believe I have used edit and replace to fix this issue but it does not seem to be working this time. Does anyone know how to fix this issue, thank you for any help in advance!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Excel 2003 Formula or Edit/Replace to delete middle initials not working

    Edit/Replace should work or you could use the formula below:
    =SUBSTITUTE(A2,".","")
    Click on star (*) below if this helps

  3. #3
    Registered User
    Join Date
    06-22-2012
    Location
    New Brunswick, NJ
    MS-Off Ver
    Excel 2003
    Posts
    53

    Re: Excel 2003 Formula or Edit/Replace to delete middle initials not working

    Edit/replace only works with initials with periods most of them do not, but I used a formula now I was just trying to avoid doing that. thank you though!

  4. #4
    Valued Forum Contributor
    Join Date
    05-08-2012
    Location
    Georgia, USA
    MS-Off Ver
    Excel 2003, 2010
    Posts
    811

    Re: Excel 2003 Formula or Edit/Replace to delete middle initials not working

    You could select an entire range and REPLACE all of the periods at once.

    This is the route I would recommend

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1