+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Replace entered values with Text upon pressing enter

  1. #1
    Registered User
    Join Date
    05-18-2009
    Location
    Columbia, TN
    MS-Off Ver
    Excel 2007
    Posts
    1

    Replace entered values with Text upon pressing enter

    How do I get Excell 2007 to replace a numeric value with text upon completion of entering the value into a cell?

    For instance, I have twelve employees that I know by number. I want to enter the value of say 1 and have Excel 2007 replace that value with the employee's name (Grindstaff) when I hit enter and do the same for all 12 employees. So, when I enter 5 into a cell and press enter I want it to replace 5 with Smithson. When I enter 9 and enter I want 9 to be replaced by Richardson, etc.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Replace entered values with Text upon pressing enter

    Welcome to the Board.

    You could techincally use Named Ranges but you would want to avoid using a Named Range of 1 etc... you would perhaps want to have

    Name: _1
    RefersTo: Terry

    Name: _2
    RefersTo: June

    etc...

    then you would enter in a Cell

    =_1

    and that would become Terry etc...

    (else you're looking at VBA I think)

+ 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