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

S

shafali

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatted to place dashes within numbers formatted as text 1
Formatting zeros as dashes 4
find the upper case letters within a cell 3
How do I add a 0 and 2 dashes to a truncated soc. sec.# in a cell 10
minus signs, or dashes in a formula or hyperlink 3
Formating a number in a cell 3
text to numbers 1
Deleting Charactors from a cell and the whole column 1

Top