substitute gives a #NAME? error

**jrtaylor** · 01-31-2018, 08:26 PM

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.

**GC Excel** · 01-31-2018, 08:31 PM

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

=SUBSTITUTE(B1,"asdfiale.dee_UIA_12OPQS",A1)

**daddylonglegs** · 01-31-2018, 08:31 PM

You would need quotes around text. THis works for me

=SUBSTITUTE(B1,"asdfiale.dee_UIA_12OPQS",A1)

**jrtaylor** · 02-05-2018, 11:19 AM

Thanks for these. I appreciate your help!

substitute gives a #NAME? error

LinkBack

Thread Tools

Rate This Thread

Display

substitute gives a #NAME? error

Re: substitute gives a #NAME? error

Re: substitute gives a #NAME? error

Re: substitute gives a #NAME? error

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Substitute Formula - Name Error

[SOLVED] Is there another way to write INDEX(INDIRECT(SUBSTITUTE()),MATCH(OFFSET(SUBSTITUTE()))?

[SOLVED] Error with Formula SUBSTITUTE

How to use a substitute formula to substitute text entries to a different text entry

Substitute "#DIV/0!" error with a symbol

[SOLVED] substitute for =

substitute

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions