Parsing data

[intensified]

Hello, another question. I have a cell that looks like:
B217F1C1-FL1-AP1
the B217 stands for building 217, the F1 stands for first floor....any way I can do a function to add those values to seperate cells? So a Floor column that would say "First Floor" and a Building column that would say "B217" based on the B217F1?

Thanks in advance! I may not post often, but I have referred MANY people to these great forums!!!

 

[tweedle]

I've got:

Building @ B2: =LEFT(A2,SEARCH("F",A2)-1)

Floor @ C2:

=SUBSTITUTE(MID(A2,SEARCH("F",A2),SEARCH("C",A2)-SEARCH("F",A2)),"F","Floor ")

Cube @ D2:

=SUBSTITUTE(MID(A2,SEARCH("C",A2),SEARCH("-",A2)-SEARCH("C",A2)),"C","Cube ")