Link to home
Start Free TrialLog in
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

asked on

Excel 2016 How to delete odd graphic characters

I inherited a worksheet with a bunch of strange characters which I was not able to delete.  I have had to cut and cut and cut.
(see video).
There must be a better way to delete these odd objects.
Avatar of Mohammed Basheer
Mohammed Basheer

Would you please try to save the excel file as CSV format?. Open it in excel and see those ghosts disappeared.
Then save back to XLSX format.
try copy the whole sheet by selecting the cells to be copied and then paste it into a new sheet with values only (Paste Special > Values) , repeat it to paste the Format, etc when it's necessary.
ASKER CERTIFIED SOLUTION
Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
D'oh?
These are shapes with MSO images. Why they are there? Who knows... ask the guy you got it from.

For getting rid of them:
Just copy the range with your data and paste values only into a new sheet.
Thanks for the points.  Glad it worked....