+ Reply to Thread
Results 1 to 3 of 3

Being driven made by Zero Width Space throughout sheet.

  1. #1
    Registered User
    Join Date
    09-16-2019
    Location
    UK
    MS-Off Ver
    O365
    Posts
    3

    Being driven made by Zero Width Space throughout sheet.

    I have a sheet which is a mixture of sharepoint list imports, pasting from a webpage etc. During this process, some zero width spaces are littered throughout the document. Of course it's helpful that I can't see them and don't know there is even an issue until I export to my other programme.

    How can I sweep through my entire sheet and REMOVE all zero width spaces? Kill them all? Dead?
    I've left the below text with some of those before the L

    ​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​​Logistics Finance & Medical​​​

    And here is what it looks like when I put it into a unicode viewer. And this is on one cell. I have 2500 rows and about 20 columns.

    APFTJEZ.png

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Being driven made by Zero Width Space throughout sheet.

    Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.

    Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.

    To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Being driven made by Zero Width Space throughout sheet.

    Administrative Note:

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. As you have so few posts here, I will do it for you this time: https://www.mrexcel.com/board/thread...sheet.1175521/.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Dynamically driven front sheet
    By tinkertot in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-26-2016, 06:43 AM
  2. Replies: 1
    Last Post: 02-20-2016, 03:42 PM
  3. [SOLVED] Tracking time until complete
    By ks100 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2015, 08:55 AM
  4. Dynamic graph driven by input-driven named ranges
    By gwebb in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-24-2015, 09:22 AM
  5. [SOLVED] Not able to remove the space between the bars in colum charts -gap width is 0%
    By Shareez Saleem in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-27-2015, 05:00 AM
  6. [SOLVED] bug on the macro coded sheet, a protected sheet, every time i made an action i wanted
    By dondonordas in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 02-22-2014, 06:46 AM
  7. Replies: 1
    Last Post: 02-22-2014, 01:28 AM

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