Excel Replace digit with Text

[mcauliff]

I have a cell that contains the numbers, 1, 2, or 3. I want to replace the numbers with text.

I tried an If statement, but unable to get it to work

=IF("1","Compaq",IF("2","WWPS-Legacy",IF("3","WWPS-Oracle")))

Do I need to put the text in a different cell. I'm trying to replace the numbers with the text.

 

[onedtent]

you need to tell excel which cell you are refering to

=IF(A1=1,"Compaq",IF(A1=2,"WWPS-Legacy","WWPS-Oracle"))

hth

 

[gizmo1973]

Do you have all three numbers in the cell or just one of three?

An IF statement needs to refer to a cell and it looks like you aren't doing this just now?

Regards, Phil.

http://www.manchester-medical-services.co.uk

 

[SkipVought]

Hi,

"... I want to replace the numbers with text."

You CANNOT do this in the cell in which the numbers reside.

You CAN do this in ANOTHER CELL, leaving the ORIGINAL CELL VALUE unchanged as onedtent suggested.
[tt]
IN B1, for instance: =IF(A1=1,"Compaq",IF(A1=2,"WWPS-Legacy","WWPS-Oracle"))
[/tt]

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]

 

[mcauliff]

Thanks to everyone that reply.

I thought that I woudl have to use another cell for the text and since the text is in a different cell, than needed to add the cell number that contained the data (A1).

The unmention item was the cells were being created from a SQL Query and I wasn't sure in I add a column to the output if it would disappear when the query was refreshed.

 

[SkipVought]

If your column is directly adjacent and to the right of the querytable range, AND you check the checkbox in Data > Get External Data > Data Range Properties, you will always get your formula calculated thru the rows of returned data from the query.

Skip,
[sub]
To be safe on the [red]FOURTH[/red],
Don't take a [red]FIFTH[/red] on the [red]THIRD[/red]
Or you might not come [red]FORTH[/red] on the [red]FIFTH[/red]
[red][highlight blue]FORTH[/highlight][/red][white][highlight red]WITH[/highlight][/white] [/sub]