Jun 11 2018
- last edited on
Jul 31 2018
Jun 11 2018 10:24 PM
The arguments you have supplied to this function are correct, so I can only think of two reasons why you might be seeing a #NAME?
1) The first argument is not being recognised as text. Double check that the speech marks are being recognised as double speech marks and not invalid characters. If you copy this exact formula from the web page and paste it into Excel, you can reproduce this error.
2) You are using a version of Excel that does not support this function. This function was introduced in an update to Office 2016.
For Desktop you can easily check by selecting Insert Function on the Formulas tab and check that a description of the function is displayed at the bottom and that all the arguments are valid.
For Mobile you will have to look closely at the individual characters. Check that the double speech marks are pointing straight down, and not slightly forward.
Jun 12 2018 01:43 AM
If you change quotation mark symbol from “ - CHAR(147) on " - CHAR(34) it shall work