开发者

Find similar or "like" text and replace it with other in excel

开发者 https://www.devze.com 2023-02-01 13:46 出处:网络
Does anyone know how i can find similar descriptions in excel andreplace them with 1 other description is there a wild card?

Does anyone know how i can find similar descriptions in excel and replace them with 1 other description is there a wild card?

i am. trying to make a pivot chart with a list of transactions and their descriptions and i want to group all my ATM withdrwls but i cant. On the pivot chart they appear as ATM Withdrwal-REF-1234 and each of these "withdrwls" have different reference and as a result they show up as individual items on the chart...how can i group say all my ATM withdrwals as 1 ATM Withrdawl item so开发者_开发知识库 that it shows a 1 atm withdrwl item on my pivot chart?


Have you considered making two fields-- one that captures the ATM Withdrwal portion of the string and one that captures the rest? It would effectively be some sort of "category" field.

It should be a fairly simple thing to do with the macro capability in excel.

0

精彩评论

暂无评论...
验证码 换一张
取 消