Share via

Excel cell cannot delete odd character

Anonymous
2017-10-03T00:57:02+00:00

I have a XL 2016 sheet that is show the attached odd character.  Not sure where it is coming from or how to get rid of it.  Image is attached. Does anyone have any ideas on this?

Thanks,

Marc.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2017-10-03T01:36:14+00:00

    Hello,

    since that character is not showing in the formula bar, check teh length of the cell

    =Len(b2)

    That should return a 3.

    If you click into the formula bar and hit the "End" key on your keyboard, where is the cursor? If it is right next to the "c", with no gap, the thing you see is not a character. It could be a drawing object.

    Hit F5 to open the GoTo dialog, click Special, tick "objects" and hit OK. Is anything selected? Is the funny character selected? If so, hit the Del key to delete the selected objects.

    Let me know how this goes. If nothing helps, share a copy of the file. You can upload a sample file to the Public folder of your OneDrive, share it and post a link here. You can access your OneDrive with the same account you use for this forum.

    6 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-10-03T14:12:04+00:00

    It indeed was an object.  Thx for the help.

    0 comments