View Single Post
  #2   Report Post  
Chip Pearson
 
Posts: n/a
Default

You haven't provided many details, but you can use the MID
function. E.g.,

=MID(A1,1,5)&"-"&MID(A1,10,5)&"-"&MID(A1,15,5)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"jamae918" wrote in message
...
I need to insert a dash at several different points in a text
string. Does
anyone know a function that will do this? Any help is
appreciated. Thanks