Challenge #22: Identify Values to Aggregate

[dominiklz]

Spoiler

[JoshKushner]

After working on Challenge #20 I think I'm ready for anything Regex. (mind you, I'm still working on how to differentiate company name and notes on that one. it's a toughie)

[dsmdavid]

Solved with formula & text to columns. Don't quite get RegEx yet...

[samN]

Regex for the Win

[Waynemk]

funny

[ggruccio]

More fun with parsing....

[LandonG]

My solution.

[PhilipMannering]

I cheated... with regex. Solution attached.

Spoiler

Normal IconsRetro Icons

[jasperlch]

Solution attached.

[SGolnik]

I started several different ways including doing text to columns using / as a delimiter but ultimately the way I decided on ended up being the same as the solution.