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.
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.
Well.... with quotes, it works for me
=SUBSTITUTE(B1,"asdfiale.dee_UIA_12OPQS",A1)
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
You would need quotes around text. THis works for me
=SUBSTITUTE(B1,"asdfiale.dee_UIA_12OPQS",A1)
Audere est facere
Thanks for these. I appreciate your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks