Not 100% sure this is what you need from your explanation but

Say in cell C6 is the word Dallas and in C7 is Austin. In cell D6
type:

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

This will result in D6 reading Dallas D. You can then copy and paste
to cell D7 which will result in D7 reading Austin A. If all you want
is the cell to look for and return the first character in the word in
C6 or C7 then in D6 or D7

=LEFT(C6,1) - or - =LEFT(C7,1)

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