I have very exciting news for you. Finally, the excel school program is ready for your consideration. We are opening registration on 8th of Feb.
(if you don’t know what Excel school is… it is a 12 week online excel training program, conducted by me. You can find full details, get a free lesson here.)
Some details & key dates about the program area,
- The price will be $97 if you pay one time
- or $37 x 3 if you make three monthly payments (total: $111)
- Registration opens on 8th Feb, 2010 (Monday) and closes on 17th Feb, 2010 (Wednesday EOD)
- Classes start on 22nd Feb, Monday.
- Classes go on until 23rd May, Sunday.
- You get complimentary access to all the content, downloads until 14th June, 2010
- The following topics will be covered.
- I have made a small PDF explaining contents, benefits, teaching methodology and pricing. you can download it here.
- You need not be online at any specific time to learn the lessons.
- However, you may want to log-in every week so that you can ask questions, keep up with the pace.
- We use Excel 2007 (but excel 2003 alternatives will be explained wherever possible)
Come back on Monday and you should see a nice sales page and few “buy me now…” buttons for you to make the payment and get on in.
Download the “Overview of Excel School Program” file [mirror] to know more about detailed contents and teaching methodology. You can also watch a video about this.
Make sure you sign up for the excel school email updates so that I can email you when the registration is ready.
10 Responses to “Multiple Find Replace with Power Query List.Accumulate()”
Note: The text-formula above miss a -1. The video is correct.
😀 sorry, I made the exact same mistake as you did - initially - in the video. {0..3} is one thing, and Table.RowCount(replacements) -->3 items ={0,1,2} is another thing.
1st question : you've created a new column to put the replacements in. how ca we replace in the original column without creating a new one ?
2nd question : how can we replace the value in the entire cell and not only the text (Using ReplaceValue instead of text.Replace) ?
Thanks you in advance
Chandoo, I would be very interested to have your answers in both Yassine's questions!
Thank you for sharing,
Vassilis
Thank you for this! I was just doing an assignment where I was having to replace words with other words in my Excel sheet. We are starting with the basics in my class, so I know I don't have a huge list that I would need to find and replace, but this is something that could be useful down the road for me!
Hi
This is nearly perfect for my needs thank you, however I would like just the "replace" to be the result if possible please, I have tried in vain adjusting the formula without success.
Thank you in advance
Thank you! Awesome tip, and very flexible, too.
My find/replace values were in non-adjacent columns of a table containing a bunch of other data. Worked prefectly and I am now a tiny bit less clueless.
Hi!!!
I have the same question that Yassine did.
I need to replace the values in the same column. I don't want to create a new column e then have to remove the old column.
How could I could that?
That's a real fun article. It inspired me to delve deeper into the topic of List.Accumulate. I can see how the function works, but it takes an additional step to imagine how one can use it for more complex applications.
Your example also made it into my article, together with some other use-cases. Would be great to get your opinion on which other areas you would include in the article.
Let me drop the link to the page so others can too find it for further reading: https://gorilla.bi/power-query/list-accumulate/
Expression.Error: The name 'replacements' wasn't recognized. Make sure it's spelled correctly.