Excel Discussion: The hard way or the concise way?

/in /by

This video is a little different than the rest. Someone needed help and I came up with 2 solutions–both shown in this video. What’s more important about this is the discussion about the hard solution vs. the concise solution.

Sometimes the hard solution serves us better because we understand it. The concise solution may look impressive, but the question is: can we explain it and be responsible for it?

The solution is for someone who needed to move parts of a string of text. She needed to “move the D.” The solutions include:

– Column from Example
– Split column by delimiter
– Merge columns
– Handling leading zeroes in Power Query
– Data Types

#LeadingZeroes
#PowerQuery
#ColumnFromExample

  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