Help with string concatenation logic

it might be easier if you attached an actual sample workbook!
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

well a few examples on the sheet would help.
i for one am not going to try and get this in your sheet,

This is a data sample:
A B C D E F
25 TEAM* TEAM
26 COOS? YES 2G 00 3G 03
27 VIP? YES
28 O//? YES
29 Metropolis? No
30 EXAM? YES
31 TECHNOLOGY* 2G & 3G
32 NETWORK ELEMENT* 01234
33 Site Owner? V// Host
34 Co-owner Site Ref. 00002
35 Co-owner TT 123456
36 ISSUE TYPE? Hardware Issue (COOS = YES)
37 ALARM Alarm Example(ONLY IF COOS = NO)

Result:
E// - COOS 2G:00 3G:03 - VIP O// EXAM - TEAM - V// 01234 - V// Host - O// 00002 - O// TT 123456 - Hardware Issue


Data Sample #2
A B C D E F
25 TEAM* TEAM
26 COOS? NO 2G 00 3G 00
27 VIP? No
28 O//? YES
29 Metropolis? YES
30 EXAM? No
31 TECHNOLOGY* 2G & 3G
32 NETWORK ELEMENT* 04567
33 Site Owner? O// Host
34 Co-owner Site Ref. 00099
35 Co-owner TT 876543
36 ISSUE TYPE? Hardware Issue (COOS = YES)
37 ALARM Alarm Example (ONLY IF COOS = NO)

Result:
E// - O// MET - TEAM - V// 01234 - O// Host - O// 00099 - O// TT 876543 - Alarm Example

I have only the issue with the B27 to B30

Following the example above: If any of those fields are set to no basically it won't have any to show but this
E// - TEAM - V// 01234 - O// Host - O// 00099 - O// TT 876543 - Alarm Example

If EXAM is YES:
E// - EXAM - TEAM - V// 01234 - O// Host - O// 00099 - O// TT 876543 - Alarm Example

If Metropolis is YES:
E// - MET - TEAM - V// 01234 - O// Host - O// 00099 - O// TT 876543 - Alarm Example

If O// is YES:
E// - O// - TEAM - V// 01234 - O// Host - O// 00099 - O// TT 876543 - Alarm Example

If VIP is YES:
E// - VIP - TEAM - V// 01234 - O// Host - O// 00099 - O// TT 876543 - Alarm Example

If all is YES:
E// - VIP O// MET EXAM - TEAM - V// 01234 - O// Host - O// 00099 - O// TT 876543 - Alarm Example

Sorry i altered at that time the string(company issues):
EDIT:
@martindwilson: I already have the code for the part, i'm just having some issues with it:

Please Login or Register  to view this content.

This is the code for the part i want to work on but there is always a space or a " - " appearing

I don't need a total code of this, just for a little help in the logic of cells B27:B30 to make them dependant on each other.

Please Login or Register  to view this content.

Result:
ANOC - COOS 2G:00 3G:03 - VIP O// EXAM - TEAM - V// 01234 - V// Host - O// 00002 - O// TT 123456 - Hardware Issue

Please Login or Register  to view this content.

Result:
ANOC - O2 MET - TEAM - VDF 01234 - O2 Host - O2 00099 - O2 TT 876543 - Alarm Example

I have only the issue with the B27 to B30

Following the example above: If any of those fields are set to no basically it won't have any to show but this
ANOC - TEAM - VDF 01234 - O// Host - O// 00099 - O2 TT 876543 - Alarm Example

If EXAM is YES:
ANOC - EXAM - TEAM - VDF 01234 - O// Host - O2 00099 - O2 TT 876543 - Alarm Example

If Metropolis is YES:
ANOC - MET - TEAM - VDF 01234 - O// Host - O2 00099 - O2 TT 876543 - Alarm Example

If O// is YES:
ANOC - O2 - TEAM - VDF 01234 - O// Host - O2 00099 - O2 TT 876543 - Alarm Example

If VIP is YES:
ANOC - VIP - TEAM - VDF 01234 - O// Host - O2 00099 - O2 TT 876543 - Alarm Example

If all is YES:
ANOC - VIP O2 MET EXAM - E// - VDF 01234 - O2 Host - O2 00099 - O// TT 876543 - Alarm Example