ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell filter deletion (https://www.excelbanter.com/excel-discussion-misc-queries/63555-cell-filter-deletion.html)

Sergio

Cell filter deletion
 
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?

Jonathan Cooper

Cell filter deletion
 
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?


Sergio

Cell filter deletion
 
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?



All times are GMT +1. The time now is 10:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com