how do transform data?

vcubedvcubed
in Computers & Internet

I want to transform some data on excel(2011). I have a column of data consisting of 3 different numbers (11, 12,22) but i want change 11 to 1, 12 to 2 and 22 to 3 onto a new column. how can i do that?? do i use the IF function. if yes, how to use IF function. there's a 1000 number and i don't want to do it manually one by one changing them.

Comments

  • eric-aeric-a

    Nest your if statements.....

    Or use the find and replace function to globally change them. Press Control-F

Sign In or Register to comment.