Substitute, lookup, isnumber help?

I've simplified what I need help with ... but I still need help! Here is the thread I started with the more complex need, but I don't need that much work any more!

http://www.excelforum.com/excel-gene...ml#post2485904


Here is the hopefully simpler task ...

I'll attach a spreadsheet with example data and explanation of what I'm trying to do. Seems like just a lot of substitute, lookup, isnumber stuff that I'm not good with! I say that because those are the functions used in the previous spreadsheet I received help with.

Thanks in advance for any help.

Mike

In A13:

=LEFT(A2,2)

copied down

in H13:

=LEFT(H2,2)

copied down

in F13:

=LEFT(F2,FIND("-",F2)-1)&"#"&IF(MID(A2,3,10)="",1,MID(A2,3,10))

copied down

in I13:

=LEFT(I2,FIND("-",I2)-1)&"#"&IF(MID(H2,3,10)="",1,MID(H2,3,10))

copied down

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

Try in F22:

=IF(ISNUMBER(FIND("-",F2)),LEFT(F2,FIND("-",F2)-1),F2)&"#"&IF(MID(A2,3,10)="",1,MID(A2,3,10))

copied down