validate text & combine specific cells

Hi,


I need to validate text & combine those values. Pls go through the attachment, i need result as in "F" Column. Pls help me

I need single formula in each cell in "F" Column (Sheet1)

thank you in advance.



regards
shiva

Hi shiva_raj,

Enter this formula in F2 and copy down

Formula:

Please Login or Register  to view this content.