combine results of LEFT and RIGHT formulas from two different cells

[tpgroup]

I would like a formula that will take the first 6 characters (LEFT) from the value in A1 and the last 8 characters (RIGHT) in A2 and combine them into a string of 14 characters in A3.

Thanks to all in advance for your help!

 

[Jonmo1]

Welcome to the board.

Try

=LEFT(A1,6)&RIGHT(A2,8)

 

[Andrew Poulsom]

Welcome to MrExcel.

Did you try?

=LEFT(A1,6)&RIGHT(A2,8)