Formula With A Specific Formatted Concatenation

[Ark68]

I am looking for a formula for cell A1 that combines the value in A2 (the last two digits of the 4 digit number), the full six digit number in A3, and the text value in A4. For example:

A2 = 2023
A3 = 000013 a number custom formatted as 6 digits
A4 = "B"

The value I'm looking for for A1 would be = "23000013B"

I have this formula,

=RIGHT(A2,2) & A3 & A4

but of course it only provides me 231B.
I did guess with this ....

=RIGHT(A2,2) & format(A3,"000000") & A4

but it of course just provided an error.

 

[Joe4]

The function is actually TEXT, not FORMAT (it is FORMAT in VBA).
So just use:

=RIGHT(A2,2) & TEXT(A3,"000000") & A4

 

[Ark68]

Sorry for the late acknowledgement. This was very helpful, thank you!

 

[Peter_SSs]

This would be another option

=MID(A2&A3&A4,3,99)