Cell filter deletion

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
please provide an example

before it looks like..........?
After you want it to look like......?
 
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.
 
Back
Top