Help help, combining limited data

[khaos]

HI guys I was wondering if you could help me with writing a formula that
meets this criteria...

1. I need to combine Text in column A to Column B (=A1&B1)
2. BUT I only need the first letter of coumn A to combine with the rest
of column B
3. Columb C needs to be <= 10 chracters

Goal :
Text in Column C for row 1 = sAAABBBCCCD
Text in Column C for row 2 = gBBBBBBCCCD

If it doesnt have to be all in one formual, I mean I can combine A and
B and then do a formula for C, i just need the results to be the first
letter of the A column combined with <= 9 digits of the Column B

--------------------------------------------
Text in column A Text in Column B
--------------------------------------------
smith | AAABBBCCCDDDEEE
george | BBBBBBCCCDDDEEE
anna | CCCBBBCCCDDDEEE
joe | AAABBBCCCDDDEEE




If someone could help me out that would be AWESOME (i'll be forever
grateful!)

 

[David McRitchie]

For string manipulations like you should check out HELP
for LEFT, RIGHT, and MID Worksheet Functions
Also see http://www.mvps.org/dmcritchie/excel/strings.htm

=LEFT(A1,1) & B1

to limit to 10 characters, as requested and as in your example:
=LEFT(A1,1)&B1,10)

or if you wanted the rightmost characters from B
=LEFT(A1,1) & RIGHT(B1,9)

 

[Bernard Liengme]

Your results are 11 characters long
For 10 characters use =LEFT(A1,1)&LEFT(B1,9)
So for 11 use =LEFT(A1,1)&LEFT(B1,10)
best wishes