Searches for first letter, returns first letter, adds comma after it

[billyheanue]

Hi all,

I'm wondering if anyone knows an excel formula to search for the first letter in a column, and return that letter. Also, bonus points for adding a comma after the first letter.

heres example column:
[TABLE="width: 65"]
<!--StartFragment--> <colgroup><col width="65" style="width:65pt"> </colgroup><tbody>[TR]
[TD="width: 65"]Clayton[/TD]
[/TR]
[TR]
[TD]Zack[/TD]
[/TR]
[TR]
[TD]Madison[/TD]
[/TR]
[TR]
[TD]Corey[/TD]
[/TR]
[TR]
[TD]David[/TD]
[/TR]
[TR]
[TD]Jacob[/TD]
[/TR]
[TR]
[TD]Chris[/TD]
[/TR]
<!--EndFragment--></tbody>[/TABLE]


Thanks all,

Bill

 

[mole999]

=left(a1,1)&","

as a formula

 

[Aladin Akyurek]

Applied to Clayton, we get what exactly?

 

[billyheanue]

C, aladin

 

[Rick Rothstein]

Give this formula a try...

=REPLACE(A1,2,99,",")

 

[Aladin Akyurek]

C, aladin

See post #2...