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!)


--
khaos
------------------------------------------------------------------------
khaos's Profile: http://www.excelforum.com/member.php...o&userid=25690
View this thread: http://www.excelforum.com/showthread...hreadid=538669