Easy Excel Question

[StepBangin]

This is probably really easy, but I dont know how to do it.

I have one column that has either FR, SO, JR, or SR in the cells... I need to change the letters to the numbers 9, 10, 11, or 12.


Anyone know how I can do it so it doesnt take forever?

[LT22]

ctrl+F

click the Replace tab, self-explanatory from there...

[SamIAm]

If you don't want to modify the original data, you can write a function like

<font class="small">Code:</font><hr /><pre>if(
A3="FR",
9,
if(
A3="SO",
10,
if(
A3="JR",
11,
12
)
)
)</pre><hr />
I just wrote it all indented so you could read it. Excel would like it better like
if(A3="FR",9,if(A3="SO",10,if(A3="JR",11,12)))

edit: Note that I'm making this up w/o checking it. I might have " instead of ', or whatever.

[stopcensoringme]

If you don't mind losing the data, do find and replace.

An alternative to the formula is simply sort the data by that column. Insert a new column and populate the 9s, Ts, etc.

[Meech]

I'd probably use a lookup table to make it extendable, nested ifs give me seizures.

But for 4 input values, i'd do the sort thing above.