How do I replace Values with text

[ppatricks]

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?

[Duane]

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 ]

[Dave Hawley]

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

[ppatricks]

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!

[Dave Hawley]

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

[ppatricks]

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

[Duane]

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.