Extracting Data from a Column: 4 Solutions 1 Problem

One way to get good at Excel is to find multiple ways to solve a problem. In this video I look at a recent problem where I pasted data into Excel from a website. The data ended up in a tall stack, and what I needed was buried in the mix.

I immediately thought of multiple ways to extract what was needed. This video shows 4 solutions and invites you to think of other solutions.

Solutions shown:
– Painful manual way … but it gets and answer
– ISNUMBER, RIGHT and IF
– Advanced Filter and Flash Fill
– Conditional Formatting

No way is “the right way.” The bottom line is to get the right answer. Take the challenge.

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition

My old blog: http://datascopic.net/blog-2-2

#OzduSoleil
#ISNUMBER
#CrapData