Concatenate 2 cells and separate with 2 hyphens

[bristolrob]

Ok my friends, i have searched for concatenating 2 cells with hyphens and have found several solutions.
I cannot however see what it is that i am after.
I would like to concatenate 2 values e.g 2453 in cell 1 and 987654321 in cell 2.
I have seen how to do the first hyphen using =CONCATENATE(A1,"-",A2)
I need to put a hyphen between the 2 values and then also hyphens between the first 2 & the next 3 of the second value as so,
2543-98-765-4321.
Your help is always appreciated.
Rob

 

[steve the fish]

You can do this:

=TEXT(A1&B1,"0000-00-000-0000")

 

[Norie]

If you have the first value in A1 and the second in B1 try this.

=A1 &"-" & LEFT(B1,2) & "-" & MID(B1,3,3) & "-" & MID(B1,6,4)

 

[bristolrob]

Many thanks, that works perfectly
You guys are really helpful.
Rob