Insert characters in a text string

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

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" <jamae918@discussions.microsoft.com> wrote in message
news:801CCA40-E712-4803-B82D-910287C4A79C@microsoft.com...
>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