Is there a formula that will take first 3 letters from cell 1 and first letter from cell 2 to create an 4 leter id code in cell 3 that can then be used in an invoice as a product code?
Ie: for the name Hurcules Johnson = hurj

I am a novice so patients and non tech terms please.
TIA

This is a first post in many that I expect will follow in these forums so A VERY BIG THANK YOU!!!