Assuming between is required, the following 71 results were found.
-
will not work for you either, nor with the VALUE() function.... The culprit was a suspicious space which had been copied in between the currency amount and the currency symbol. Microsoft could argue this is a problem with your data but the way I see it...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
In column G put the formula: =MID(B1, FIND(F1, B1)+1, FIND("°", B1, FIND(F1,B1)) - FIND(F1,B1) - 1) // if there is a space between the two =MID(B1, FIND(F1, B1)+2, FIND("°", B1, FIND(F1,B1)) - FIND(F1,B1) - 2) In column H put the formula:...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
function (row_content, row_index) { // clear and declare the array var column_values = []; // regex to ignore commas between double-quotes var column_values = row_content.split(/,(?=(?:(?:[^"]*"){2})*[^"]*$)/); // prevents JS error where results...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
type an easy to remember word for this set of options, eg. "portrait". Now click outside of the option box at the end (in between where it says +1 more) Type the word "value" and press Now type the string of words/phrases that you want to store against...
- Type: Article
- Author: Joel Lipman
- Category: Graphic Design
- Language: *
-
Requests to use money transfer services like Western Union or MoneyGram. These services are not meant for transactions between strangers. In our experience they’re favoured by fraudsters. One popular trick is to ask you to prove that you have funds by...
- Type: Article
- Author: Joel Lipman
- Category: IT Support
- Language: *
-
make no mention of using MD5 in an encryption task. Why? I'm trying to create an ETag for a synchronization process between Zoho Creator and Zoho CRM. Combining all the fields to compare into a single field can't be done via the documented methods...
- Type: Article
- Author: Joel Lipman
- Category: Zoho Deluge
- Language: en-GB
-
The Google Chrome Frame (or ChromiumBrowser) is quick to enable. Simply ask your webmaster to put the following meta tag in between the head tags of the page: For Joomla v1.5.x Administrators: Login to the backend admin panel Go to Extensions > Template...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
reports in SSRS has always been a date range rather than just the one date. The user must be allowed to select all results between two dates instead of just specifying the one day. If the second parameter (ToDate) is the same as the first (FromDate),...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: *
-
lists the day, date, room name, start/finish times, booking details and the staff contact. I want an empty row to appear between each day in the list, so I have: Monday 03/10/2011 Main Office 09:00 17:00 Notes Monday 03/10/2011 Boss' Office 09:00 17:00...
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html
to migrate old content to a new system. From a MediaWiki CMS to a SaaS called Service-Now. The previous interlinking between images could no longer be used. How? There were a few functions out there. One called "strip_tags" crashed in the running of the...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
CSS Fieldsethttps://www.joellipman.com/articles/cms/website-development/css/css-fieldset.html
horizontal space between label and fieldset fieldset label.inline { display: inline-block; margin-left: 2em; } Change color of fieldset grouping line fieldset { border: 2px ridge #7abcff; }
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: en-GB