Re: Complex if and mid function.

From: brookdale <brookdale.1rcgfu_1119974963.0291@xxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 28 Jun 2005 09:43:05 -0500

I think I have it!

=MID(IF(ISBLANK(C2),K2,C2),(SEARCH(" *
",(IF(ISBLANK(C2),K2,C2)),20))+1,3)

Now I just have a few issues here.

1. This searches columns C and K. Only one of them will contain data.
The other will be blank. Occasionally both will be blank. In this case
I need a blank cell to be returned. Right now I am getting a #VALUE!.
How can I fix this?

2. This next one may sound odd, but I need it for a more simple
equation. Say this solution picks up a M for Monday. Sometimes there is
a space or two before and after the M solution. I need to only have the
M. Is there like a "Nospaces" function or something I can add in here?

Thanks.

--
brookdale
------------------------------------------------------------------------
brookdale's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24617
View this thread: http://www.excelforum.com/showthread.php?threadid=382788

.

Follow-Ups:
- Re: Complex if and mid function.
  - From: bj
- Re: Complex if and mid function.
  - From: brookdale

References:
- Complex if and mid function.
  - From: brookdale

Prev by Date: How do I import Names of Windows files into an Excel Spread ***
Next by Date: Re: Finding the 3rd largest number in a list
Previous by thread: Complex if and mid function.
Next by thread: Re: Complex if and mid function.
Index(es):
- Date
- Thread