editing original content with #NAME error

J

JustMe

Suppose a cell has this content : "=+ hechtingen". This gives a #NAME error.

How can I remove the "=" (or replace it) by using functions? Normal
comparison only addresses the value of the cell as "#NAME".

Thanks!
 
J

JustMe

My problem got solved on the Dutch discussion group:

Ctrl+H (Find and Replace), Replace the "=" by nothing, Click either Replace
or Replace All.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replacing a phrase with carriage returns 1
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
Can't save my Office documents (after computer rebuild and reauthorization) 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
Resctricting editing rights, but allowing those who cant edit, to still copy the slides 0
Merging from an Excel file with graphics 1
Word macro that can call cells out of Excel for a find and replace 0
React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0

Top