how to show only text in excel cell?

in my excel column shows number and text, i want to hide number, has to shows only text. i have attached my excel sheet as well. In Relationship and Entity common name. the data inside these columns are "number;#and then value like "Client" or "Vendor"(2;#Vendor). so what i wanted to do is, need to display only "Vendor". how can i do it? i have to apply the formulas for whole "D" and "E". Please guide me.

Try this in a new column. I inserted one between E and F of your example sheet.

Formula:

Please Login or Register  to view this content.

Excellent, it works fine. Thanks a lot