Replace text after punctuation

J

jgoods

I have a number of cells that have text, some sort of punctuatio
(example : or -) followed by text. An example of cell would be; tex
text text: text text text.
I want to remove the punctuation as well as the following text by usin
the find & replace function. Is there some sort of criteria I can us
that would do this?

Thank
 
B

Bernard V Liengme

To make it simple, lets use Find/Replace to have only one punctuation.
Now select the cells and use Data|Text to Columns and specify that the text
is delimited by what ever punctuation symbol was used.
Best wishes
Bernard
 
Top