forming a column from another one

[pinar]

Hi I have a question regarding to excel. I have a column includes numbers. It
is like;
Number:
10
10
7
7
23
55
40
I need specific numbers, lets say that, I only need number 10, 7 and 23 and
then I have to form a new column by using the data in the number column, for
example
If the number is 10 write AA
If the number is 7 write PM
If the number is 23 write HZ
And the other numbers can be deleted or can be 0
So at the end , I have to have something like that
Number Name
10 AA
10 AA
7 PM
7 PM
23 HZ
55 0
40 0
I have around 7 different numbers .Is there any body knows how to do it in
excel. better without writing any macro?
Thanks a lot

 

[JulieD]

Hi

you can use Edit / Replace and replace 10 with 10 AA - etc
- you will have to do this individually for your 7 numbers

Or

if you have 7 or less numbers to append info to then you can use an IF
statement in an adjoining column
=IF(A1=10,"10 AA",IF(A1=7,"7 PM",IF(A1=23,"23 HZ",IF(A1=1,"1 yy",IF(A1=2,"2
xy",IF(A1=3,"3 yy",IF(A1=4,"4 zz",A1 & " 0")))))))

you can then copy this down the column, once you've done with select the
column and copy it
select the original column and choose edit / paste special - values to
replace the original number with the new ones. You can then delete this
temporary column.

Hope this helps
Cheers
JulieD

 

[pinar]

thnk you
but i am trying with if function with 7 data but it gives error
=IF(F3=334,"10 AA",IF(F3=305,"7 PM",IF(F3=320,"23 HZ",IF(F3=362,"
yy",IF(F3=363,"2xy",IF(F3=580,"3 yy",IF(F3=360,"4 zz",F3 & " 0")))))))
i write like tha

 

[IC]

thnk you
but i am trying with if function with 7 data but it gives error
=IF(F3=334,"10 AA",IF(F3=305,"7 PM",IF(F3=320,"23 HZ",IF(F3=362,"1
yy",IF(F3=363,"2xy",IF(F3=580,"3 yy",IF(F3=360,"4 zz",F3 & " 0")))))))
i write like that

I cut/pasted your formula to Excel and it works fine here. You don't say
what the error is.

 

[pinar]

thnks
it works no