Sometimes such a simple thing makes the difference when you’re staring at a lot of data in Excel. I always set this just in case I’ve got some duplicate records that were missed on a data dump.
You output 5000 rows of data into Excel for a client to review and need to make them all HREFs. The records in the excel come out of the database which their site uses and includes ArticleIDs that their site uses a URL variable to select the correct Article. We have this: ArticleID URL 456 And… Continue reading Automatically create a URL/HREF in an Excel field