View original (French)

Excel, add a character to a cell

Solved
Cridelateur -  
 musky -
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
Configuration: Windows XP Internet Explorer 6.0

3 réponses

Réponse 1 / 3
eriiic Posted messages 24581 Registration date   Status Contributeur Last intervention   7 281
 
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
48
Rosie
 
Thank you!!!!
It helps me too!! :0)

Rosie
0
Laé
 
thank you very much
0