software

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

quot;Sergioquot; wrote:

gt; I have about 1400 cells that i need to delete the information AFTER a certain
gt; word. My issue is anything after, in the cell, X400 needs to get deleted. For
gt; example, i have a cell that says X400:c=us\;a= \;p=First
gt; Organizati\;o=Exchange\;s=Little\;g=Cindy\; but in 1400 cells and its every
gt; 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.

quot;Jonathan Cooperquot; wrote:

gt; please provide an example
gt;
gt; before it looks like..........?
gt; After you want it to look like......?
gt;
gt; quot;Sergioquot; wrote:
gt;
gt; gt; I have about 1400 cells that i need to delete the information AFTER a certain
gt; gt; word. My issue is anything after, in the cell, X400 needs to get deleted. For
gt; gt; example, i have a cell that says X400:c=us\;a= \;p=First
gt; gt; Organizati\;o=Exchange\;s=Little\;g=Cindy\; but in 1400 cells and its every
gt; gt; cell is different. Any suggestions?