如何在excel中得到所需的输出？

发布于 2024-11-26 09:44:07 字数 799 浏览 0 评论 0原文

请告诉我如何执行以下操作。

假设我有一个 A 列。
如果第 3 行第一个字段中的数据是

XPWCS432, XPWCS440, XPWCS394, XPWCS395, XPWCS396, XPWCS397, XPWCS398, XPWCS399, XPWCS476, XPWCS390, XPWCS391
XPWCS432, XPWCS470
XPWCS432, XPWCS434, XPWCS312, XPWCS313, XPWCS314, XPWCS315, XPWCS316, XPWCS317, XPWCS318, XPWCS319, XPWCS320, XPWCS321, XPWCS322, XPWCS323, XPWCS324, XPWCS325, XPWCS326, XPWCS327, XPWCS328, XPWCS329, XPWCS330, XPWCS331, XPWCS372, XPWCS332

输出数据应如下所示

1) 不带前导和尾随逗号 2) 值之间不能有空格，不能重复，值之间应以逗号分隔

应满足以下条件。

1) 如果出现在字符串开头，请删除 ,（逗号）。
2) 删除字符串中的所有空格。
3）对字符串单词进行升序排序，并删除字符串中的重复单词。

字段中的数据（单词）逐行变化，即column1 row1 field1可能包含3个单词
row2 field1 可能包含 10 个单词
row3 field1 可能包含 20 个单词
像这样可能有大约 100 行。
谢谢，斯里海

原文

Please tell me how to do the below.

Say I have a single column A.
If the data in the 1st 3 rows 1st field is

XPWCS432, XPWCS440, XPWCS394, XPWCS395, XPWCS396, XPWCS397, XPWCS398, XPWCS399, XPWCS476, XPWCS390, XPWCS391
XPWCS432, XPWCS470
XPWCS432, XPWCS434, XPWCS312, XPWCS313, XPWCS314, XPWCS315, XPWCS316, XPWCS317, XPWCS318, XPWCS319, XPWCS320, XPWCS321, XPWCS322, XPWCS323, XPWCS324, XPWCS325, XPWCS326, XPWCS327, XPWCS328, XPWCS329, XPWCS330, XPWCS331, XPWCS372, XPWCS332

The output data should be like below

1)with out leading and traiiling comma
2)No spaces between values,no duplicates and values should be comma seperated

The below conditions should be achieved.

1) Remove the ,(comma) if it appears at the starting of string.
2) Remove any blank spaces in the string.
3) sort the string words in ascending and remove the duplicate words in the string.

The data(words) in the field are changing from row to row i.e column1 row1 field1 may contain 3 words

row2 field1 may contain 10 words
row3 field1 may contain 20 words

like this there may be say some 100 rows.
Thanks,
Srihai

分享到QQ

分享到微博