I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find.
I tend to do data manipulation in SQL Server rather than Excel, as it is generally easier to do it in SQL where I can run commands sequentially. However, there are times when I do need to do it in Excel.
I recently needed to replace one part of a string of text and really…
Continue Reading azurecurve’s Article on their blog
Excel Snippets: Substitute Function
I might not post many Excel snippets, but I’m collecting them into a small Excel Snippets series to make them easy to find. I tend to do data manipulation in SQL Server rather than Excel, as it is…
Blog Syndicated with azurecurve’s Permission