how do transform data?
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
Nest your if statements.....
Or use the find and replace function to globally change them. Press Control-F