I have been using this forum now for a few days and I just wanted to
thank everyone for their help. I am 17, in my first job, and because I
am the only person here able to work with excel equations, I am being
asked to do a lot of stuff. But I only took a short excel class in 7th
grade! I am learning it all now, but I need solutions fast.

Here is one equation that I have so far:

=if(mid(c2,22,1)="M",mid(c2,22,3),if(mid(c2,22,1)= "T",mid(c2,22,3),if(mid(c2,22,1)="W",mid(c2,22,3), if(mid(c2,22,1)="F",mid(c2,22,3),mid(H2,22,3)

I have two columns, C and H. One of them is blank and the other will
contain the necessary script at space 22/3 characters. However, which
column I need occurs somewhat randomly. So here is my question...

Is there a more efficient way to write this? Really I would like to
say

=if(mid(c2,22,1)="any letter",mid(c2,22,3),mid(h2,22,3))

However, I don't know if there is away to notate the part in red. I
tried a "*", but it doesn't seem to work. my equation does the job, but
it seems to be very inefficient.

Thanks.


--
brookdale
------------------------------------------------------------------------
brookdale's Profile: http://www.excelforum.com/member.php...o&userid=24617
View this thread: http://www.excelforum.com/showthread...hreadid=382478