Thread: Inserting a hyphen after the 3rd character
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] pjamorton@hotmail.com is offline
external usenet poster
  
Posts: 11
Default Inserting a hyphen after the 3rd character
Hi All,

I am looking for a way to insert a hyphen (-) in a cell after the
third character. For example,

123456789 turns into 123-456789. Any ideas? Thanks in advance!!! Jen
Reply With QuoteReply With Quote