+ Reply to Thread
Results 1 to 14 of 14

Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

  1. #1
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Something is seriously wrong somewhere.

    All instances
    the switch is not on but off
    gets automatically translated to
    the switch is not on but "**f"
    .

    Please explain Why?
    Last edited by Winon; 03-08-2014 at 10:43 AM. Reason: problem with "**" displaying as "**"

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    27,051

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    I noticed this also and sent a Contact Us message. Unfortunately the masking ** the characters also masks what you are trying to show in your post.

    It appears that the letter "o" immediately followed by the letter "f" is being masked. I thought it was just in thread titles but it may be in all post content. Here is the first one I noticed but there are at least three threads in the last 12 hours with this problem in their titles:

    http://www.excelforum.com/excel-prog...ice-64bit.html

    I would d**f my cap to anyone who can solve this problem that is **ten frustrating. Meanwhile I'm **f to review more new threads.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Thank you for your participation in this problem.

    Question is, how do we get it solved?

    I have even asked Leith Ross for his assistance, lacking personal contact details ** the "Big Guns" ** this Forum.

    Just maybe, the so called "Tech Team" is totally missing the bus!

    ** course you will understand that it totally peeves me **f!!!

    Kind Regards.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

  4. #4
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Sad thing about this that even VBA commands like Offset are being retricted to this to read **fset.

    Masking the first f with BB-Code will help (either colour or bold, italic or underline should do fine). The first occurrance of the mentioned command was explicitely being marked with black colour.

    Ciao,
    Holger

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Holger thanks for sharing that trick.

    Unfortunately this is not the solution in the problem.TT??!! is away.... There are-until this time-4 threads for this problem.

    Is anyone hearing us??!!
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  6. #6
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    @ HaHoBe,

    Hi Ciao, A.K.A. Holger,

    Sorry my friend. I just could not resist the above, since many users think your name is "Ciao".

    I truly believe that you came up with an absolute BRILLIANT!!! solution for the interim, but the Tech Team has to solve this unwanted annoyance!

    Best Regards

  7. #7
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Thank you Fotis1991,

    I agree with you!

    But in the meantime I shall use Holger's "Trick".

    Kind regards.

  8. #8
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 365 on Win11 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Hi, Fotis,

    there should be a substitution list which may be available via Admin Control Panel (but I have no knowledge how things are managed in vBulletin 4.x). If the TT has encrypted it in a script only they would be able to take those two letters off the list. DLL has taken notice of that problem in another thread (there愀 another one in the Water Cooler about the same subject). Sadly this doesn愒 only apply to new threads but affects the old ones as well.

    We actually hear you, maybe let愀 start to chant (okay, maybe all jump into the air on 3: 1, 2 ... ... there was something I wanted to say?!?)

    @Winon:
    I found it frustrating that a VBA command was masked by asteriks and passed on by mail to a user - I never would have suspected a VBA command to be necessary to mask. The more things change the more we need to go back and remember solutions we foudn in earlier days...

    Regarding Ciao:
    not the worst name people may choose to address me - the ratio between Ciao and Holger being almost 1 as I used it on most of my posts.

    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you

  9. #9
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    @ HaHoBe,

    Agree!

    We come a long way, and that is why, as far as I am concerned, you will remain a Friend!

    Kind Regards.

  10. #10
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,060

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Hi Winon

    Quote Originally Posted by Winon View Post
    Last edited by Winon; Today at 11:18 AM. Reason: "**" gets replaced with "**"
    lol
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-

  11. #11
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    Microsoft 365
    Posts
    14,759

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Quote Originally Posted by Winon View Post
    .....I just could not resist the above, since many users think your name is "Ciao".
    Sometimes people here refer to me as "Audere"
    Audere est facere

  12. #12
    Forum Guru Winon's Avatar
    Join Date
    02-20-2007
    Location
    East Rand, R.S.A.
    MS-Off Ver
    2010
    Posts
    6,113

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    @ddl,

    Appreciate that Audere!

    Kind Regards.

  13. #13
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,167

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Sorry guys, i wasnt active on the forum today so didnt see this until a few minutes ago. I have sent this to the tech team but its midnight here, so this will be taken care ** in the morning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  14. #14
    Forum Expert
    Join Date
    01-23-2013
    Location
    USA
    MS-Off Ver
    Microsoft 365 aka Office 365
    Posts
    3,863

    Re: Glitch. The word, or characters such as "**", automatically translates to "**". WHY???

    Thank you arlu.

    I was going to post this anomaly, but I see that I am the tail ** the dog, with the same substitution problem everyone else is experiencing.

    Lewis

    NOTE: This problem affects old posts too. All my old posts going back to last year contain the same '**' instead o f 'o' and 'f'.
    Last edited by LJMetzger; 03-08-2014 at 04:56 PM. Reason: Added NOTE re old posts.

+ 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. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  2. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  3. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  4. [SOLVED] Removing ".", "?" or "!" from last word of sentence and replacing it later in vba.
    By staggers47 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-16-2013, 07:20 AM
  5. [SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row
    By eltonlaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-17-2012, 06:26 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