Challenge #69: Web Stock Data

[tammybrown_tds]

Spoiler

[Sylvana]

My solution. Just using "Text to Columns":

Spoiler

[A2H]

Spoiler

[kaianderson]

I learned something new with this one.

The switch function is very cool.

[joshbennett]

Here is my solution!

[mollyhatch]

Spoiler

[kmedici]

Spoiler

[Scythe80]

Spoiler

Not too much different from what I have seen from others. I needed to refer to one person's solution for the initial Text to Columns though. Can someone explain how the "\n" works as a delimiter in text to columns? I didn't notice it within the extract, and would never have thought to use it.

[dicky5150]

Spoiler

[beccat]

My solution.