SQL Track at Orlando Code Camp

One of the things I worked on as part of SQLSaturday Orlando last year was increasing the engagement with the local .Net group (ONETUG). One of the offshoots of that is that they’ve invited the SQL groups to chair the SQL track this year for Code Camp. Kendal asked for feedback on what kind of […]

Read more "SQL Track at Orlando Code Camp"

Excel Substitute and Replace

Maybe I knew this and had to relearn it, but was momentarily stumped when I needed to do some quick clean up and started to use the replace function. The syntax for it seemed strange:     Turns out what I needed was Substitute. Here’s what the help page says: Substitutes new_text for old_text in […]

Read more "Excel Substitute and Replace"