ExcelBanter - I want to add dashes in a cell which has both number and tex

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I want to add dashes in a cell which has both number and tex (https://www.excelbanter.com/excel-discussion-misc-queries/188393-i-want-add-dashes-cell-has-both-number-tex.html)

shafali

I want to add dashes in a cell which has both number and tex

I want to add dashes in a cell which has both number and text. for example, a
cell contaion 10G101211100011 and i want to change it to 100G-1012-1110-0011.
Is there a formula i can use?

dhstein

I want to add dashes in a cell which has both number and tex

=LEFT(A1,4)&"-"&MID(A1,5,4)&"-"&MID(A1,9,4)&"-"&RIGHT(A1,4)

"shafali" wrote:

I want to add dashes in a cell which has both number and text. for example, a
cell contaion 10G101211100011 and i want to change it to 100G-1012-1110-0011.
Is there a formula i can use?

All times are GMT +1. The time now is 04:23 PM.