View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Penny[_2_] Penny[_2_] is offline
external usenet poster
 
Posts: 1
Default Adding hyphen to text in cell

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