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