+ Reply to Thread
Results 1 to 4 of 4

substitute gives a #NAME? error

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    648

    substitute gives a #NAME? error

    I'm getting a NAME error when using SUBSTITUTE on a text block (see attached workbook)

    Not sure why this is happening. I've tried using with and without quotes around the new text but this didn't solve the problem.

    Any advice? Thanks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,407

    Re: substitute gives a #NAME? error

    Well.... with quotes, it works for me

    =SUBSTITUTE(B1,"asdfiale.dee_UIA_12OPQS",A1)
    GC Excel - My blog

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: substitute gives a #NAME? error

    You would need quotes around text. THis works for me

    =SUBSTITUTE(B1,"asdfiale.dee_UIA_12OPQS",A1)
    Audere est facere

  4. #4
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    648

    Re: substitute gives a #NAME? error

    Thanks for these. I appreciate your help!

+ 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. [SOLVED] Substitute Formula - Name Error
    By sl729 in forum Excel General
    Replies: 5
    Last Post: 07-21-2016, 11:46 AM
  2. Replies: 4
    Last Post: 10-28-2014, 11:04 PM
  3. [SOLVED] Error with Formula SUBSTITUTE
    By alexxgalaxy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-08-2013, 10:16 AM
  4. How to use a substitute formula to substitute text entries to a different text entry
    By andybocchi in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-01-2010, 07:50 PM
  5. Substitute "#DIV/0!" error with a symbol
    By Vbort44 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-08-2008, 07:26 PM
  6. [SOLVED] substitute for =
    By CEN7272 - ExcelForums.com in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. [SOLVED] substitute
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2005, 06:05 AM

Tags for this Thread

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