Google グループは Usenet の新規の投稿と購読のサポートを終了しました。過去のコンテンツは引き続き閲覧できます。
表示しない

=clean(a1)

閲覧: 1 回
最初の未読メッセージにスキップ

news.verizon.net

未読、
2003/08/25 15:29:252003/08/25
To:

I want to get rid of special characters from A1. But I want it to be
replaced with space so there are 2 or 3 words:

A1

TESTchar(27)TEST1char(7)TEST2

After clean it should look like this

TEST TEST1 TEST2

Thanks.


Dave Peterson

未読、
2003/08/25 18:08:032003/08/25
To:
if it's just char(27) and char(7):
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(27)," "),CHAR(7)," ")

And if there's a chance that those characters will be doubled up:
=TRIM(SUBSTITUTE(SUBSTITUTE(A1,CHAR(27)," "),CHAR(7)," "))

--

Dave Peterson
ec3...@msn.com

新着メール 0 件