I have column that consists of following data:
我的列包含以下数据:
XYZAB XYZAC XYZAD XYZAE
XYZAB XYZAC XYZAD XYZAE
XYZ may be any digit from 100 to 200,000
XYZ可以是100到200,000之间的任何数字
The column may contain only first value or in any combination with other value e.g
该列可以仅包含第一值或与其他值组合,例如
XYZAC
XYZAC XYZAE
XYZAB XYZAD XYZAE
XYZAB XYZAD XYZAE
I need to extract all adjacent digits to AB, AC, AD and AE and copy them to another column.
我需要将所有相邻的数字提取到AB,AC,AD和AE,然后将它们复制到另一列。
Your help is highly appreciated.
非常感谢您的帮助。
Regards
1 个解决方案
#1
0
Please try: Replace ?? with , then something like:
请尝试:替换?用,然后像:
=LEFT(A1,LEN(A1)-2)
copied down to suit, then select all, Copy, Paste Special, Values followed by select column and Text to Columns with Space as the delimiter. Sort the columns and move to suit.
向下复制到适合,然后选择全部,复制,选择性粘贴,值,然后选择列,将文本复制到带有空格的列作为分隔符。对列进行排序并移动以适应。
#1
0
Please try: Replace ?? with , then something like:
请尝试:替换?用,然后像:
=LEFT(A1,LEN(A1)-2)
copied down to suit, then select all, Copy, Paste Special, Values followed by select column and Text to Columns with Space as the delimiter. Sort the columns and move to suit.
向下复制到适合,然后选择全部,复制,选择性粘贴,值,然后选择列,将文本复制到带有空格的列作为分隔符。对列进行排序并移动以适应。