+ Reply to Thread
Results 1 to 5 of 5

The formula(s) doesn't work in excel installed on a certain computer

  1. #1
    Registered User
    Join Date
    11-04-2018
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    2

    The formula(s) doesn't work in excel installed on a certain computer

    I've got the following formula to extract a substring before the hyphen character (-) from cell A2:

    =LEFT(A2, SEARCH("-",A2)-1)

    extract-text-before-char.png

    -If I enter the same formula and text string as shown in the picture above in Google Sheets, it works fine as expected.
    -If I enter the same formula in Excel file where Office 365 is installed on my work computer, it works fine as well.


    *Error: If I enter the same formula where Office 365 is installed on my personal computer, I'm getting a warning message as shown in the picture below:

    ghjgh.png

    As you may see in my formula, the highlighted cell A2 is not recognized by Excel.

    P.S.
    If I try to enter a simple formula like '=SUM(A3+A4)', it works as expected.
    I'm only getting errors by entering more complex formulas like:

    =RIGHT(A2,LEN(A2)-SEARCH("-",A2))
    =MID(A2, SEARCH("-",A2) + 1, SEARCH("-",A2,SEARCH("-",A2)+1) - SEARCH("-",A2) - 1)
    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B3,"color_new",C3),"color_old",D3),"level",A3)


    Does anyone know the reason of this issue?

    Thanks in advance!
    Last edited by yaxo; 11-04-2018 at 02:50 PM.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,866

    Re: The formula(s) doesn't work in excel installed on a certain computer

    Perhaps your personal computer has regional settings which are not English, so Excel is expecting semicolons instead of commas. Look at the help box below your formula - it shows the syntax of the formula with semicolons.

    Hope this helps.

    Pete

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    6,779

    Re: The formula(s) doesn't work in excel installed on a certain computer

    What are the results of you entering =LEFT(A2,4) into a cell and =SEARCH("-",A2)-1 into another cell?

    BSB

  4. #4
    Forum Contributor
    Join Date
    10-08-2018
    Location
    Lima, Peru
    MS-Off Ver
    Office 365 ProPlus
    Posts
    115

    Re: The formula(s) doesn't work in excel installed on a certain computer

    As you can see in the image that you posted, the formula helper is clearly expecting a semicolon to separate the arguments.
    Change all commas to semicolons in your formulas, or change the number format settings in the PC.
    Attached Images Attached Images

  5. #5
    Registered User
    Join Date
    11-04-2018
    Location
    London, England
    MS-Off Ver
    Office 365
    Posts
    2

    Re: The formula(s) doesn't work in excel installed on a certain computer

    Solved: changed the regional language.

    Thank you folks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. MacroOptions crashes Excel 2010 and OLEObjects doesn't work on some computer.
    By angelintoon in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-15-2015, 07:02 AM
  2. Replies: 8
    Last Post: 12-15-2014, 04:36 PM
  3. [SOLVED] VBA doesn't work on different users of the same computer
    By cobermayer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-03-2013, 11:26 AM
  4. Excel 2007 : my excel doesn't work properly in my computer
    By Red Buscato in forum Excel General
    Replies: 1
    Last Post: 05-15-2012, 06:03 AM
  5. why this macro doesn't work in my boss computer!?
    By matador_24 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-22-2011, 12:35 PM
  6. DATEDIF formula doesn't work on computer that uses different locale
    By Timoluege in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-29-2011, 09:49 AM
  7. Replies: 4
    Last Post: 04-19-2006, 07:56 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1