Changing alpha numeric data in one cell into something else

[Tricia0923]

Hi,
This is my problem,
in cell A2 I have 6D in cell A3 I want it to read 1:40.

I think IF functions only work with alpha data, right??

Been looking into this for a while and am getting VERY frustrated.

Thanks!

Tricia

[Moo the Dog]

IF functions work with just about anything... However, I am completely confused as to how 6D relates to 1:40. Do you have an example worksheet you could upload?
- Vince

[FDibbins]

im with you on that Moo, maybe some greater explication please?

[Tricia0923]

I work for a college and 6D stands for the sixth hour class during the day which is offered at 1:40
We also have a 1D, 2D, 3D, 4D etc and then evening courses are coded as 1E, 2E etc.
when I added a column next to the code column where the 6D is located and then typed in the formula
=IF(A2=6D, "1:40","") I get an error message.

I hope this helps. Thanks for helping!

Tricia

[Moo the Dog]

=if(a2="6D","1:40","")

You need the quotes around 6D so that Excel sees it as a text string. Otherwise, it thinks you are referring to a cell address or named range.

- Moo

[Moo the Dog]

Tricia,

Basically, if you're looking to compare A2 to text you will need the quotes. If you were looking to see if A2 equals a number, a numeric value derived from another formula, a named range/cell or an actual cell address (like D12), then you don't need the quotes. Hope that helps!

- Moo

[Tricia0923]

=if(a2="6D","1:40","")

You need the quotes around 6D so that Excel sees it as a text string. Otherwise, it thinks you are referring to a cell address or named range.

- Moo

Hi Moo,
I thought I did that!!
I just tried it on a new Excel sheet and it worked like a charm!!

I was trying this for over an hour to no avail!!

Ok, I'm good.

Problem solved!

Thanks so much!!

[FDibbins]

you could also put all those codes and times into a table, and use =vlookup to find whichever code you enter into A2