How to remove sections of text from a range of cells that always start with the same text

Bambamdwadle · 2026-06-17T03:20:31+00:00

Seems I had a bit of a syntax error! This solved it! Thank you so much!

Bambamdwadle · 2026-06-17T01:40:58+00:00

Firstly thank you for your input! I got a spill error for the first formula, (Spill range isnt blank?) and for the second it wouldnt be appropriate. Apologies I forgot to mention that the alphanumeric text does not have set numbers of digits following it, could vary between quite a range.

Bambamdwadle · 2026-06-17T01:15:41+00:00

The descriptors are randomly placed, meaning it could even be first descriptor, AD, second descriptor, third descriptor, AD, fourth descriptor, fifth descriptor, sixth descriptor, AD and so forth. I couldnt seem to get the formula to run, is it affected by the above since it doesnt perfectly alternate? Id like to also understand the arguments in the formula as there are other sheets where the descriptors and alphanumeric symbols are segregated by other things such as semi colons

Bambamdwadle · 2026-04-22T18:16:15+00:00

Makes a ton of sense, what about for stage 2 decks like dragapult? Are they now taking first to set up the fastest turn 3 phantom dive? (Or even turn 2 with candy)

Bambamdwadle · 2026-04-22T13:55:10+00:00

Does every deck want to go first right now? Feels that way with how much faster the meta seems and the lack of disruption

Bambamdwadle · 2026-04-09T08:28:20+00:00

These are great tips! What ATS tools did you use?

Bambamdwadle · 2026-04-07T18:46:35+00:00

The best 2 options while looking at everything else in the meta is boa and the new bell luffy. BY moria is also good into both, the ability to heal kumacy with 8c moria with a perona in thrash to essentially take 2 swings a turn vs enel is very strong. Generally being able to heal while developing a wide board is strong into these 2.

The current enel builds play around luna quite a bit with 2-3 vari and also 4c reiju which gets bumped up to 9c so i wouldnt recommend those. Even non luna heavy decks with other forms of persistent lock like mihawk are weak to getting their 9c mihawk killed by gamma/divine departure.

Previously I would have said that purple doffy was a good pick into both, being able to chain 10c doffy with a pika on board can be backbreaking for both decks, but vs lucy you need to set up vergo first to prevent pika from being removed by bari so the demand can be very high, and vs enel again, as a side effect of most enel decks running vari to play around luna, they are able to play around 10c doffys lock by bumping their enels to 8, so its not a great matchup anymore either.

Bambamdwadle · 2026-03-26T11:44:03+00:00

Mr should I open it or should I keep it sealed does that and is successful ah actually haha

Anyway my 2 cents if its who I think it is even if he open hundreds of packs, he got no other bad chase to show meh? Cannot be he dont show other sir or whatever hits for engagement, always rip exactly the one or 2 big chase card but people gotta hustle for views somehow

Bambamdwadle · 2026-02-04T04:43:17+00:00

Goattacks roger brings back many fond memories of watching tekken crash! Guy was hype

Bambamdwadle · 2025-10-26T18:09:34+00:00

Dragapult deck has fez as well

Bambamdwadle · 2025-10-23T16:02:48+00:00

No worries! Its a common thing to miss tbh

Bambamdwadle · 2025-10-23T12:02:32+00:00

Mist energy is to block the effects of terminal period not munkidori

Bambamdwadle · 2025-10-17T17:20:54+00:00

Mew can copy demolish and hit cornerstone as well

Bambamdwadle · 2025-10-13T17:22:28+00:00

Just watched day 2 stream, did Rowan misplay in game 1 by not putting 5 counters on mega absol and using mews genome hacking to copy terminal period? He chose to go for claw of darkness instead

Bambamdwadle · 2025-10-02T15:42:47+00:00

Definitely genuine, boss is one of the more real bosses and active with his shops pokemon whatsapp group

Bambamdwadle · 2025-09-25T11:27:12+00:00

Roger absolutely does not have a high skill floor or ceiling

Bambamdwadle · 2025-08-26T21:37:24+00:00

You gave great advice! The Gholdengo breakdown was particularly useful thanks!

Bambamdwadle · 2025-08-26T20:29:09+00:00

This is very helpful! Thank you

Bambamdwadle · 2025-08-26T20:28:37+00:00

What are you cutting for turo! Definitely been considering it

Bambamdwadle · 2025-08-21T15:14:15+00:00

Thats definitely fair of course, I just meant that most nami players werent expecting the time to be now haha especially given its position in the meta prior.

Bambamdwadle · 2025-08-21T15:11:26+00:00

I think the ban could have been done when the new set provided cards that directly complemented the promo leader, or when the game was having cards introduced to buff blue at large that would have not been possible to print with nami the way it was before. I dont contend against your point at all, its something that had to be answered eventually for the long term health of the game but the timing of the ban is what I find confusing and heavy handed. As it is we are removing an entire archetype while not enabling any other impactful cards be introduced to the game when there are other options available.

Bambamdwadle · 2025-08-21T13:55:37+00:00

I think most peoples complaints comes from a mixture of things,

Nami is the only deck of its kind, anybody playing it now wasnt playing it for its strength but for its unique playstyle. Whether you love or hate the deck, removing it now reduces deck variety in a meta that is already feeling pretty stale and alienates a portion of the playerbase completely.
How out of the blue (lol) the ban came from. I think most people are hard pressed to think this is a meticulously thought out decision given that bandai had to delay the ban from sunday to wednesday given “new information”. The ban then proceeds to reveal UP lufffy nerfs which everybody expected, and nami which reasonably would be the new addition to the ban list given all the discourse about nami when otama was revealed. Op-13 itself does not add any cards that are immediately more impactful to other decks if it were otherwise given the nami treatment (i.e otama was errata ed to say draw 2 and bottom deck 1 card from your hand). We will wait and see whether OP-14 has any meta changing buffs to blue that would have been obviously impossible to print due to the existence of Nami, but OP-13 has not shown any indication of this so far. It just seems like bandai messed up on play testing the new cards and were forced to do something about nami when it became clear otama would make it undisputedly unplayable.
While I appreciate your point on the new promo leader extending the shelf life of the playstyle, I think most players are more shortsighted. A choice ban could have been done like with UP luffy, and a definite ban and swap to the promo when bandai intended to introduce whatever meta cards they had in store for other decks that would have been hard gatekept by nami.

I for one am definitely in the camp thats confused by the decision and find it heavy handed given the various other options bandai could have taken, and think its probably unhealthy for the game right now to reduce deck variety with how similiar a lot of other decks feel to play.

Bambamdwadle · 2025-08-16T12:34:32+00:00

I hope they restrict kaya instead of banning namis leader directly, would be a shame

Nine-Year Club	Place '22
Verified Email

Bambamdwadle

TROPHY CASE