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......?

"Sergio" wrote:

> 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?

This is in the cell,
SMTP:(E-Mail Removed);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.

"Jonathan Cooper" wrote:

> please provide an example
>
> before it looks like..........?
> After you want it to look like......?
>
> "Sergio" wrote:
>
> > 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?