I am trying to format my excel spreadsheet. One column in the sheet has a lot of extraneous data I need to get rid of, example:
我正在尝试格式化我的Excel电子表格。工作表中的一列有很多我需要摆脱的无关数据,例如:
Product Dimensions: 11.1 x 10.3 x 2.5 inches ; 2 pounds Shipping Weight: 1.6 pounds (View shipping rates and policies) Shipping: Currently, item can be shipped only within the U.S. and to APO/FPO addresses. For APO/FPO shipments, please check with the manufacturer regarding warranty and support issues. Origin: Denmark ASIN: B00C9X591Q Item model number: 6024464 Manufacturer recommended age: 7 - 12 years Amazon Best Sellers Rank: #111 in Toys & Games (See Top 100 in Toys & Games) #9 in Toys & Games > Building & Construction Toys > Building Sets Average Customer Review: 4.8 out of 5 stars See all reviews (298 customer reviews) Would you like to give feedback on images?
产品尺寸:11.1 x 10.3 x 2.5英寸; 2磅运输重量:1.6磅(查看运费和政策)运输:目前,物品只能在美国境内运送到APO / FPO地址。对于APO / FPO货件,请与制造商联系以了解保修和支持问题。原产地:丹麦ASIN:B00C9X591Q产品型号:6024464制造商推荐年龄:7 - 12年亚马逊畅销产品排行榜:玩具和游戏排名第111(玩具和游戏排名前100)玩具和游戏排名第9>建筑玩具>建筑套房平均顾客评价:4.8,满分5星查看所有评论(298位顾客评论)您是否想提供图片反馈?
I wan't to be able to find and delete all information in this list EXCEPT "ASIN: XXXXXXXXXX" I have been trying to use excel find and replace with wildcard expressions but have had little luck so far.
我无法找到并删除此列表中的所有信息除了“ASIN:XXXXXXXXXX”我一直在尝试使用excel查找并替换为通配符表达式但到目前为止运气不佳。
Thanks!
1 个解决方案
#1
3
I'm assuming the ASIN number is always the same length.
我假设ASIN号始终是相同的长度。
Add the following to a new cell =MID(A1,FIND("ASIN",A1,1),16)
将以下内容添加到新单元格= MID(A1,FIND(“ASIN”,A1,1),16)
#1
3
I'm assuming the ASIN number is always the same length.
我假设ASIN号始终是相同的长度。
Add the following to a new cell =MID(A1,FIND("ASIN",A1,1),16)
将以下内容添加到新单元格= MID(A1,FIND(“ASIN”,A1,1),16)