Assume cell A1 contains FIRST and cell B1 contains SECOND, put the following formula in cell C1 to concantate (join together) the first three letters in each cell:
=LEFT(A1,3)&LEFT(B1,3)
Observe the results in C1 as FIRSEC
The first three letters are JON. The last three letters are NES.
The first three letters in the word storage are S,T,and O
HEART The first four letters 'hear' refer to the function of the middle three letters, 'ear.' The last three letters 'art' is stuff that you do.
Ark
art
ail
cog
ice
Nap
meeting
'w', 'h' and 'a'.
entrainment