answersLogoWhite

0

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

User Avatar

Wiki User

15y ago

What else can I help you with?