If you've tried to split or separate text string that's delimited by commas ( or semicolons) it's a straight forward process using the text to columns feature. However if you have some values that are enclosed in parenthesis or brackets and you don't want that text to be separated, it wouldn't work. There is a workaround that this video goes through. One is a VBA solutions provided from iliace at the mrexcel forum (https://www.mrexcel.com/board/threads...) and the other is an adjustment to the text with find/replace before using the text to column feature.
Thursday, June 3, 2021
Sunday, May 30, 2021
Filtering Tables on Multiple Criteria in Excel
To filter a range of data just got a bit more interesting with the new Dynamic Array functions in Office 365. This video will cover the FILTER function which is currently only available in O365 Excel, but I'll also give an alternative way to do range / table filtering if you don't have Microsoft Office 365.
Thursday, May 27, 2021
3 Ways to Swap Columns in Excel
Swapping or moving columns around in your data set can be a fairly simple exercise. It's a simple step of cut and paste. But if you were to move or re-arranging a data set that has a lot of columns or you're working with someone that wants to see how it looks like this or that (multiple times) it becomes a burden. This video covers three ways to move columns around. The first two are using the mouse and cursor to move it around. The last example uses the newer dynamic array function called SORTBY and gives you an effective and dynamic way to swap columns around and change it effortless through multiple times.
Subscribe to:
Posts (Atom)