Excel, add a character to a cell Solved

Question

Hello,  I would like a formula that can add the character "-" in the fourth position from the left of a cell.  Cell A1: 19920003978 Desired result: 1992-0003978  Thank you

eriiic · Accepted Answer

Hello,   To add the character "-" at the 4th position from the left of a cell (A1), you need to use the following formula:  =LEFT(A1,4)"-"&MID(A1,5,20) eric

Mike-31 · Answer

Hello,  Several ways to do it quickly if the numbers have the same number of characters  Format/Cell/Number/Custom and in the input box enter 0000-0000000  Otherwise with a formula  A+

hadi_fh · Answer

Hello, and another one: =LEFT(A1,4) & "-" & RIGHT(A1,LEN(A1)-4) hadi

Excel, add a character to a cell

3 answers

I don’t know, i don’t understand anything, i’m 76 years old and i’m not sure

No internet connection possible

Put in the correct order

Unable to open xsl and xslx files

How to create an imail

Self-invoking js function

Access to google internet tab blocked

Very slow computer

Unusable screen

Print a page in the right orientation under windows 11