View original (French)

Insert a hyphen in a concatenate formula

Meve -  
cbauf Posted messages 5337 Registration date   Status Contributor Last intervention   -
Hello,

In Excel 2013, in a concatenation formula, I want to insert
a hyphen between the 2 values. Here is my formula since I need to take the first 3 digits from cell A2, concatenate it with the first 4 digits from cell B2:

=LEFT(A2,3)&"-"&LEFT(B2,4)

Thank you

Configuration: Windows / Mozilla 11.0

1 answer

Answer 1 / 1
cbauf Posted messages 5337 Registration date   Status Contributor Last intervention   803
 
Hello,

=LEFT(A2,3)"-"&LEFT(B2,4)

--
A detailed question, a precise answer! ☼► If the question is resolved, check the desired option. Update your software! and... Thank you is not a luxury ♪♫.
2