Having 3,00,000 database and want to replace:
1 with AAA
2 with BBB
3 with CCC
One by one replace is taking too much time. How i can do it in one step for all three?
Having 3,00,000 database and want to replace:
1 with AAA
2 with BBB
3 with CCC
One by one replace is taking too much time. How i can do it in one step for all three?
Sunny Ujjawal
Ctrl-H: Find and Replace
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
This i know..it give one word replacement only..i want to replace bulk
Ctrl-H for find replace
Ctrl-F for find
A small loop of code, and a table of the replacements will work, then.
Sheet2:
A B 1 1AAA 2 2BBB 3 3CCC
Amend ranges to suit.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks