This formula helps to calculate delivery costs when all you have is weights and a cost array to work with. You can't use VLOOKUP in this case as it won't find the correct value. This formula uses INDEX and MATCH together.
Today I made something beautiful. But you probably have to appreciate excel formulas to appreciate this! This formula is used to create aliases or slugs.
We use slugs to create custom URL's for our products and categories, since we ditched our SEF URL component due to speed issues we now store them as a single line in the database.
Simply replace A1 and A2 with your Product Title and SKU respectively.
This formula uses regular expressions to replace all special characters by only allowing a-z A-Z and 0-9 and spaces. You can add more exclusions by putting them into the  square brackets. Just change A1 to the cell you have in your sheet.
This code is great for making products display all at the same height when you are showing lots on a page. It can keep everything in line nicely. Make sure that your title text displays the full content that you are truncating though for better SEO.
I use this code a lot and it's quite useful to have handy. This is code that works anywhere in a Joomla component or module that displays or hides content based on the current logged in users group status. You can add and minus the group ID's by removing or adding to the in_array line. To find the Joomla group ID's just goto Users > Groups and it's on the right hand furthest column.
This formula removes all the carriage returns from a cell. We find a lot that suppliers tend to have extra formatting in their descriptions that can mess up your imports, this code will resolve that.