+ Reply to Thread
Results 1 to 3 of 3

Reverse of replacing a name with an initial

  1. #1
    Registered User
    Join Date
    08-02-2013
    Location
    Reading, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Reverse of replacing a name with an initial

    Does anyone know if you can do the reverse of replacing a name with an initial

    e.g.

    Type in JB and it replaces with Joe Bloggs

    I guess this is a sort of "find and replace" but in advance?? I'm sure you could do this on a very early version of office but it might only have been in word.

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 insider Version 2505 Win 11
    Posts
    24,744

    Re: Reverse of replacing a name with an initial

    Select File, Options, Proofing, Auto Correct. Set your values in the Auto Correct Table.

    Alan
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  3. #3
    Registered User
    Join Date
    08-02-2013
    Location
    Reading, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Thumbs up Re: Reverse of replacing a name with an initial

    Alan you are most definitely a Forum Guru!! Thanks very much. you have saved me hours of type mine and my colleagues names.

    Neilos

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] First Name & Last Initial
    By mycon73 in forum Excel General
    Replies: 5
    Last Post: 01-01-2013, 02:45 PM
  2. Replies: 3
    Last Post: 03-09-2012, 03:19 PM
  3. Reverse Data In A Cell / Reverse Cell Contents
    By nostawydoc in forum Excel General
    Replies: 5
    Last Post: 12-18-2009, 05:20 PM
  4. [SOLVED] Last initial
    By Mike Rogers in forum Excel General
    Replies: 14
    Last Post: 01-28-2006, 12:19 PM
  5. [SOLVED] Remove middle initial from "first name middle initial"
    By Justin F. in forum Excel General
    Replies: 15
    Last Post: 09-26-2005, 02:05 PM

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