ExcelBanter - Insert characters in a text string

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Insert characters in a text string (https://www.excelbanter.com/excel-worksheet-functions/19524-insert-characters-text-string.html)

jamae918

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

Chip Pearson

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

All times are GMT +1. The time now is 05:15 AM.