Thread: Inserting a hyphen after the 3rd character
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Inserting a hyphen after the 3rd character
Pete_UK wrote...
One way:

=LEFT(A1,3)&"-"&RIGHT(A1,LEN(A1)-3))
....

Shorter, simpler, more efficient to use

=REPLACE(A1,3,0,"-")
Reply With QuoteReply With Quote