=IF(LEFT(C6,1)="D",C6&" "&LEFT(C6,1),"")

This would return the text in column C6 followed by it's first letter
only if the first letter is D. So if C6 was Dallas then it would
read:

Dallas D

Otherwise it would keep the cell blank.

If all you want is the D then:

=IF(LEFT(C6,1)="D","D","")

Change the D in parenthesis to whatever letter you want the formula to
look for.



Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=488720