XL2011-Extract single character & apend with dependent "+1" function

[StephenK2]

Ok, so here's some info and the dilemma:
Excel 2011 on Windows 7

Dilemma: I have data and am trying to extract just the first character from the cell and then appending an 8-digit number (ie: 00000001) to it. However I have two character variables: letters "J" and "P". Pictures are worth a thousand words, so...
http://www.flickr.com/photos/spk0912/5919824998/
I want Row 4 Column A to appear as: J2
I want Row 7 Column A to appear as: P2

How do I do that?!!!
P.S. I am working on my mac right now so the picture you see is from Numbers, but that was just b/c it was easier to get the picture off of my computer...I am working on Excel 2011 on a PC. And FYI, Opportunity Type COHN is actually cell F2.
My code so far is: =LEFT(F2,1)&VALUE(0)+1
But, I see how this does not take into consideration of the "P" variable or the additional seven zero's that I want to appear.
Like I said, I need some assistance and I would greatly appreciate some guidance. Thank you to all who can point me in the right direction.

-Stephen

yes, this is my 1st post....I think I will be here frequently from now on!!!!

 

[Dazzawm]

Pictures are worth a thousand words, so...

They may be if we could see them! Better to download and use http://www.excel-jeanie-html.de/index.php?f=1

 

[StephenK2]

I have fixed the link...sorry about that...was working on the edit screen waiting for the picture to load...didn't load so I appended the link.

 

[StephenK2]

Anyone have a grasp on this? I know a lot of people are very busy so I'll be patient! Thank you in advance!
-Stephen

 

[mvptomlinson]

Hi Stephen, perhaps try this in A2 and fill down:

=LEFT(F2,1)&TEXT(COUNTIF($F$2:F2,F2),"00000000")

 

[StephenK2]

Mvptomlinson......
Thank you so much!!! This has saved my hide. Worked perfectly!!!!
Thank you!!!!
-Stephen