Results 1 to 3 of 3

Unknown Character Creation/Deletion

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,056

    Unknown Character Creation/Deletion

    One of my users, when saving an Excel spreadsheet from our shared drive to her local desktop, has her data changed by the addition of an unknown character in the front of many columns (but not all). See the example attached.

    If I do a Text to Columns with one of these columns I wind up with 2 empty columns. If I do a TRIM function on one of these columns I end up with an empty colum. If I do a COPY of the character, I can paste it in to do a Find and Replace. All I've found I CAN do is a CLEAN, which seems to do the trick.

    My question is, how do we prevent this from happening? Why is the data changing?

    Any help is greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1