Try

=LEFT(A1,1)&"-"&MID(A1,2,999)

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Tue, 24 Mar 2009 08:12:01 -0700, Penny
wrote:

I would like to add a hypen to the text that exists on the excel sheet. Is
there a formula for this?

example of text on sheet without hypen:
G212DA

text with hypen:
G-212DA