Not sure why do you think the Bible or any translation is at odds with this... and in this I'll answer the OP's question.
"No one has ever seen God" - this refers to the Father, who isnt manifested, but absolute.
Son is the Father manifested - "the one who has seen Me has seen the Father", Son is God showing Himself in manifested world, thus Alpha and Omega - but Father is infinite.
Holy Spirit is Spirit of God, which may make one believe "well this is the same as the Father" but it's not (been there). If you look where and how the Spirit appears in the Bible, it is for instances upon the world or individuals in action. Father is absolute and unmanifested, so we must go through the Son to know Father, and in the NT we get begotten - Holy Spirit is in us, but this doesn't mean we're the supreme Father God.
Father and the Holy Spirit are not exactly the same. You cannot look at individual verses alone to get a comprehensive picture but you need to pull all references.
Spirit us simply what makes you you. You have your spirit, God has His. Essence. God's spirit or essence is Love. So it's easy to understand how the Father and the Son and also us share in the same Spirit.
We are made in God's image. We have mind that is not manifested (Father), word and right hand (works) and body that manifest us in the world (Son, body of Christ), and who we are (Spirit). God is love. The word persons or even "faces" (in my native language) is not the most fortunate choice since God is vast and escapes words (which is why God directs us to look at the image we are made in to understand Godhead), but word was chosen because Father Son and Spirit biblically interact. Our mind and body and spirit also interact, but it's still one being.