It is not always possible to use the great Text to Columns tool. (Missed that post? Read it here.) You may need to use the LEFT function in Excel to ‘peel off’ part of a data entry. Remember, it is easy to do for a couple of entries. However, if you have 100s of entries, or thousands, you need to automate the process. Continue reading “Left, Left, Left, Right, Left”
Teaching BI skills, bit by byte