Cell filter deletion

[Guest]

I have about 1400 cells that i need to delete the information AFTER a certain
word. My issue is anything after, in the cell, X400 needs to get deleted. For
example, i have a cell that says X400:c=us\;a= \;p=First
Organizati\;o=Exchange\;s=Little\;g=Cindy\; but in 1400 cells and its every
cell is different. Any suggestions?

 

[Guest]

please provide an example

before it looks like..........?
After you want it to look like......?

 

[Guest]

This is in the cell,
SMTP:[email protected];X400:c=us\;a= \;p=First
Organizati\;o=Exchange\;s=Little\;g=Cindy\;

i would like to delete everything after the email address in every cell in a
colum.