removing anchors

0

I have converted a word file to excel and need to remove the anchors so i can edit the formulas. The anchors are in all the cells, how do i remove all of them at one time.

Answer
Discuss

Discussion

Can you post a sample file? Just edit your question and upload it.
don (rep: 1297) Dec 22, '17 at 1:26 pm
Thanks Don.  But doing that discloses the file,, I can't do that of course file is confidential material... 
HS1 Dec 22, '17 at 9:20 pm
Add to Discussion

Answers

0

by ctrl A and then delete

Discuss

Discussion

Thank you.... 
HS1 Dec 22, '17 at 9:20 pm
Add to Discussion
0

The "Anchors" are the product of a faulty method of importing the data from Word into Excel. Instead of removing them you should change the method so that you don't have them in the first place. You may find some guidance here.

Discuss

Discussion

Thank you. 
HS1 Dec 22, '17 at 9:21 pm
Glad to have been of help. Let me know how you are making out. If you got all you needed please accept the answer. It may help others to save time.
Variatus (rep: 1133) Dec 22, '17 at 10:47 pm
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login