Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 7 of 7

Thread: How do I replace Values with text

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to replace values with text
    for example:

    Customer = "2595"
    Customer = "PNY Technology"

    What formula do I need to link the number to the text?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Fort McMurray, AB
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I suppose you could just use Edit|Find, enter the number you wish to replace, then click the "Replace" button and enter the text with which you want to replace the number, and then hit the Replace All button.

    If this isn't good enough, then I may not be quite understanding what you want. Either wait for someone else to try, or repost some clarification.

    _________________
    Regards, Duane

    [ This Message was edited by: Duane on 2002-04-02 16:28 ]

  3. #3
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi ppatricks

    Try this.

    1. Go to Insert>Name>Define
    2. Try: PNY_Technology in the Names in Workbook box.
    3. Type =2595 in the Refers to box
    4. Click Add, the Cancel


    From now on the text PNY_Technology will have the value of 2595



  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi & thanks for you help, however the association I need is number to words, and excel doesn't seem to like that.

    I am trying to link account numbers to account names:

    column 1 = number
    column 2 = name

    The data that I already have is numbers
    I have the names, however do not know how to link the two automatically, (I have to do this manually evey month) and it takes forever as the list is growing!

    HELP!

  5. #5
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi

    I am not sure I have understodd you, but a Lookup table maybe the best way.

    Put all your numbers in Column "A" and all ascociated names on corresponding cells in Column "B"

    Then assume you have the number 2595 in cell D1, use:

    =INDEX($A$1:$B$2000,MATCH(D1,$B$1:$B$2000,0),1)

    This would return PNY Technology



  6. #6
    New Member
    Join Date
    Apr 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thank you... this is exactly what I needed


    On 2002-04-03 00:54, Dave Hawley wrote:
    Hi

    I am not sure I have understodd you, but a Lookup table maybe the best way.

    Put all your numbers in Column "A" and all ascociated names on corresponding cells in Column "B"

    Then assume you have the number 2595 in cell D1, use:

    =INDEX($A$1:$B$2000,MATCH(D1,$B$1:$B$2000,0),1)

    This would return PNY Technology



  7. #7
    Board Regular
    Join Date
    Mar 2002
    Location
    Fort McMurray, AB
    Posts
    218
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was just about to suggest a vlookup (or index/match) but I thought it might be more complicated than necessary.

    Thanks, Dave - I guess I didn't quite understand what was needed.
    Regards, Duane
    Office2010 in Win7

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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